DBA Data[Home] [Help]

APPS.FTP_BR_TRANSFER_PRICE_PVT dependencies on FTP_TRANSFER_PRICE_RULE

Line 183: -- in the FTP_TRANSFER_PRICE_RULE table.

179: -- DeleteTransferPriceRuleRec
180: --
181: -- DESCRIPTION
182: -- Deletes a Transfer Price Rule Definition by performing deletes on records
183: -- in the FTP_TRANSFER_PRICE_RULE table.
184: --
185: -- IN
186: -- p_obj_def_id - Object Definition ID.
187: --

Line 196: delete from ftp_transfer_price_rule

192: --------------------------------------------------------------------------------
193: IS
194: BEGIN
195:
196: delete from ftp_transfer_price_rule
197: where object_definition_id = p_obj_def_id;
198:
199: END DeleteTransferPriceRuleRec;
200:

Line 284: -- FTP_TRANSFER_PRICE_RULE table.

280: -- CopTransferPriceRuleRec
281: --
282: -- DESCRIPTION
283: -- Creates a new Transfer Price Rule Definition by copying records in the
284: -- FTP_TRANSFER_PRICE_RULE table.
285: --
286: -- IN
287: -- p_source_obj_def_id - Source Object Definition ID.
288: -- p_target_obj_def_id - Target Object Definition ID.

Line 303: insert into ftp_transfer_price_rule (

299: --------------------------------------------------------------------------------
300: IS
301: BEGIN
302:
303: insert into ftp_transfer_price_rule (
304: object_definition_id
305: ,line_item_id
306: ,currency
307: ,cond_sequence

Line 355: from ftp_transfer_price_rule

351: ,nvl(p_creation_date,creation_date)
352: ,FND_GLOBAL.user_id
353: ,sysdate
354: ,FND_GLOBAL.login_id
355: from ftp_transfer_price_rule
356: where object_definition_id = p_source_obj_def_id;
357:
358: END CopyTransferPriceRuleRec;
359: