APPS.FTP_BR_PREPAYMENT_PVT dependencies on FTP_PREPAYMENT_RULE

Line 147: -- in the FTP_PREPAYMENT_RULE table.

143: -- DeletePrepaymentAssumptionRecs
144: --
145: -- DESCRIPTION
146: -- Deletes a Prepayment Rule Definition by performing deletes on records
147: -- in the FTP_PREPAYMENT_RULE table.
148: --
149: -- IN
150: -- p_obj_def_id - Object Definition ID.
151: --

Line 160: delete from ftp_prepayment_rule

156: --------------------------------------------------------------------------------
157: IS
158: BEGIN
159:
160: delete from ftp_prepayment_rule
161: where object_definition_id = p_obj_def_id;
162:
163: END DeletePrepaymentAssumptionRecs;
164:

Line 223: -- FTP_PREPAYMENT_RULE table.

219: -- CopTransferPriceRuleRec
220: --
221: -- DESCRIPTION
222: -- Creates a new Prepayment Rule Definition by copying records in the
223: -- FTP_PREPAYMENT_RULE table.
224: --
225: -- IN
226: -- p_source_obj_def_id - Source Object Definition ID.
227: -- p_target_obj_def_id - Target Object Definition ID.

Line 243: insert into ftp_prepayment_rule (

239: IS
240:
241: BEGIN
242:
243: insert into ftp_prepayment_rule (
244: object_definition_id
245: ,line_item_id
246: ,currency
247: ,cond_sequence

Line 303: from ftp_prepayment_rule

299: ,FND_GLOBAL.user_id
300: ,sysdate
301: ,FND_GLOBAL.login_id
302: ,FTP.FTP_PPR_ASSUMPTION_ID_SEQ.NEXTVAL
303: from ftp_prepayment_rule
304: where object_definition_id = p_source_obj_def_id;
305:
306: END CopyPrepaymentAssumptionRecs;
307:

Line 334: v_ppr_id FTP_PREPAYMENT_RULE.PPR_ASSUMPTION_ID%TYPE;

330: --------------------------------------------------------------------------------
331: IS
332: -- Declare program variables as shown above
333:
334: v_ppr_id FTP_PREPAYMENT_RULE.PPR_ASSUMPTION_ID%TYPE;
335: v_obj_id FTP_PREPAYMENT_RULE.OBJECT_DEFINITION_ID%TYPE;
336: v_ln_id FTP_PREPAYMENT_RULE.LINE_ITEM_ID%TYPE;
337: v_currency FTP_PREPAYMENT_RULE.CURRENCY%TYPE;
338: v_seq FTP_PREPAYMENT_RULE.COND_SEQUENCE%TYPE;

Line 335: v_obj_id FTP_PREPAYMENT_RULE.OBJECT_DEFINITION_ID%TYPE;

331: IS
332: -- Declare program variables as shown above
333:
334: v_ppr_id FTP_PREPAYMENT_RULE.PPR_ASSUMPTION_ID%TYPE;
335: v_obj_id FTP_PREPAYMENT_RULE.OBJECT_DEFINITION_ID%TYPE;
336: v_ln_id FTP_PREPAYMENT_RULE.LINE_ITEM_ID%TYPE;
337: v_currency FTP_PREPAYMENT_RULE.CURRENCY%TYPE;
338: v_seq FTP_PREPAYMENT_RULE.COND_SEQUENCE%TYPE;
339:

Line 336: v_ln_id FTP_PREPAYMENT_RULE.LINE_ITEM_ID%TYPE;

332: -- Declare program variables as shown above
333:
334: v_ppr_id FTP_PREPAYMENT_RULE.PPR_ASSUMPTION_ID%TYPE;
335: v_obj_id FTP_PREPAYMENT_RULE.OBJECT_DEFINITION_ID%TYPE;
336: v_ln_id FTP_PREPAYMENT_RULE.LINE_ITEM_ID%TYPE;
337: v_currency FTP_PREPAYMENT_RULE.CURRENCY%TYPE;
338: v_seq FTP_PREPAYMENT_RULE.COND_SEQUENCE%TYPE;
339:
340: CURSOR cur_ppr IS

Line 337: v_currency FTP_PREPAYMENT_RULE.CURRENCY%TYPE;

333:
334: v_ppr_id FTP_PREPAYMENT_RULE.PPR_ASSUMPTION_ID%TYPE;
335: v_obj_id FTP_PREPAYMENT_RULE.OBJECT_DEFINITION_ID%TYPE;
336: v_ln_id FTP_PREPAYMENT_RULE.LINE_ITEM_ID%TYPE;
337: v_currency FTP_PREPAYMENT_RULE.CURRENCY%TYPE;
338: v_seq FTP_PREPAYMENT_RULE.COND_SEQUENCE%TYPE;
339:
340: CURSOR cur_ppr IS
341: SELECT PPR_ASSUMPTION_ID, OBJECT_DEFINITION_ID,

Line 338: v_seq FTP_PREPAYMENT_RULE.COND_SEQUENCE%TYPE;

334: v_ppr_id FTP_PREPAYMENT_RULE.PPR_ASSUMPTION_ID%TYPE;
335: v_obj_id FTP_PREPAYMENT_RULE.OBJECT_DEFINITION_ID%TYPE;
336: v_ln_id FTP_PREPAYMENT_RULE.LINE_ITEM_ID%TYPE;
337: v_currency FTP_PREPAYMENT_RULE.CURRENCY%TYPE;
338: v_seq FTP_PREPAYMENT_RULE.COND_SEQUENCE%TYPE;
339:
340: CURSOR cur_ppr IS
341: SELECT PPR_ASSUMPTION_ID, OBJECT_DEFINITION_ID,
342: LINE_ITEM_ID,CURRENCY, COND_SEQUENCE

Line 343: FROM FTP_PREPAYMENT_RULE

339:
340: CURSOR cur_ppr IS
341: SELECT PPR_ASSUMPTION_ID, OBJECT_DEFINITION_ID,
342: LINE_ITEM_ID,CURRENCY, COND_SEQUENCE
343: FROM FTP_PREPAYMENT_RULE
344: WHERE OBJECT_DEFINITION_ID = p_target_obj_def_id;
345:
346: BEGIN
347: OPEN cur_ppr ; -- open cursor