APPS.CN_LEDGER_JOURNAL_ENTRIES_API dependencies on CN_LEDGER_JOURNAL_ENTRIES_S

Line 43: cn_ledger_journal_entries_s.nextval,

39: (batch_id, srp_period_id, balance_id, credit, debit, je_date,
40: ledger_je_id, reason)
41: (SELECT X_batch_id, srp_per.srp_period_id, X_account,
42: X_credit, X_debit, X_date,
43: cn_ledger_journal_entries_s.nextval,
44: batch.reason
45: FROM cn_srp_periods srp_per,
46: cn_ledger_je_batches batch
47: WHERE salesrep_id = X_salesrep_id

Line 51: SELECT cn_ledger_journal_entries_s.currval INTO JE_Return FROM dual;

47: WHERE salesrep_id = X_salesrep_id
48: AND period_id = X_period_id
49: AND batch.batch_id = X_batch_id);
50:
51: SELECT cn_ledger_journal_entries_s.currval INTO JE_Return FROM dual;
52:
53: RETURN JE_Return;
54:
55: END New_JE;

Line 100: cn_ledger_journal_entries_s.nextval,

96: X_account,
97: X_credit,
98: X_debit,
99: X_date,
100: cn_ledger_journal_entries_s.nextval,
101: batch.reason
102: FROM cn_srp_periods srp_per,
103: cn_ledger_je_batches batch
104: WHERE salesrep_id = X_salesrep_id

Line 112: SELECT cn_ledger_journal_entries_s.CURRVAL INTO JE_Return FROM dual;

108: AND batch.batch_id = X_batch_id);
109:
110: --dbms_output.put_line('Insert ...' || SQL%rowcount);
111:
112: SELECT cn_ledger_journal_entries_s.CURRVAL INTO JE_Return FROM dual;
113:
114: RETURN JE_Return;
115:
116: END New_JE;

Line 144: cn_ledger_journal_entries_s.nextval, X_reason

140: (batch_id, srp_period_id, balance_id, credit, debit, je_date,
141: ledger_je_id, reason)
142: (SELECT X_batch_id, srp_per.srp_period_id, X_account,
143: X_credit, X_debit, X_date,
144: cn_ledger_journal_entries_s.nextval, X_reason
145: FROM cn_srp_periods srp_per
146: WHERE salesrep_id = X_salesrep_id
147: AND period_id = X_period_id);
148:

Line 149: SELECT cn_ledger_journal_entries_s.currval INTO JE_Return FROM dual;

145: FROM cn_srp_periods srp_per
146: WHERE salesrep_id = X_salesrep_id
147: AND period_id = X_period_id);
148:
149: SELECT cn_ledger_journal_entries_s.currval INTO JE_Return FROM dual;
150:
151: RETURN JE_Return;
152:
153: END New_JE;