[Home] [Help]
18:
19: CURSOR c_accounts(cv_sequence_id NUMBER)
20: IS
21: SELECT *
22: FROM fv_ye_sequence_accounts
23: WHERE sequence_id = cv_sequence_id
24: ORDER BY order_by_ctr;
25: l_module_name VARCHAR2(200) := g_module_name || 'copy_record';
26: l_errbuff VARCHAR2(300);
116: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
117: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
118: 'ACCT_ID ='||C_ACCOUNTS_REC.SEQUENCE_ACCT_ID);
119: END IF;
120: INSERT INTO fv_ye_sequence_accounts
121: (sequence_id,
122: sequence_acct_id,
123: account_flag,
124: from_account,