DBA Data[Home] [Help]

APPS.PFT_BR_ACCT_REL_CONS_PVT dependencies on PFT_ACCT_REL_CONS_RULES

Line 123: -- PFT_ACCT_REL_CONS_RULES table.

119: -- CopyAcctRelConsRec
120: --
121: -- DESCRIPTION
122: -- Creates a new Account Relationship Consolidation Rule Definition Formula by copying records in the
123: -- PFT_ACCT_REL_CONS_RULES table.
124: --
125: -- IN
126: -- p_source_obj_def_id - Source Object Definition ID.
127: -- p_target_obj_def_id - Target Object Definition ID.

Line 142: INSERT INTO PFT_ACCT_REL_CONS_RULES (

138: --------------------------------------------------------------------------------
139: IS
140: BEGIN
141:
142: INSERT INTO PFT_ACCT_REL_CONS_RULES (
143: acct_rel_cons_obj_def_id
144: ,processing_table
145: ,condition_obj_id
146: ,load_secondary_rel_flag

Line 166: FROM pft_acct_rel_cons_rules

162: ,SYSDATE
163: ,FND_GLOBAL.login_id
164: ,object_version_number
165: ,col_tmplt_obj_id
166: FROM pft_acct_rel_cons_rules
167: WHERE acct_rel_cons_obj_def_id = p_source_obj_def_id;
168:
169: END CopyAcctRelConsRec;
170:

Line 177: -- in the PFT_ACCT_REL_CONS_RULES table.

173: -- DeletAcctRelConsRec
174: --
175: -- DESCRIPTION
176: -- Deletes a Account Relationship Consolidation Rule Definition by performing deletes on records
177: -- in the PFT_ACCT_REL_CONS_RULES table.
178: --
179: -- IN
180: -- p_obj_def_id - Object Definition ID.
181: --

Line 190: DELETE FROM pft_acct_rel_cons_rules

186: --------------------------------------------------------------------------------
187: IS
188: BEGIN
189:
190: DELETE FROM pft_acct_rel_cons_rules
191: WHERE acct_rel_cons_obj_def_id = p_obj_def_id;
192:
193: END DeleteAcctRelConsRec;
194: