APPS.CN_LEDGER_JOURNAL_ENTRIES_API dependencies on CN_LEDGER_JOURNAL_ENTRIES

Line 1: PACKAGE BODY CN_LEDGER_JOURNAL_ENTRIES_API as

1: PACKAGE BODY CN_LEDGER_JOURNAL_ENTRIES_API as
2: /* $Header: cnsbjeb.pls 115.4 2001/10/29 17:12:38 pkm ship $ */
3:
4: /*
5: Date Name Description

Line 11: Name : CN_LEDGER_JOURNAL_ENTRIES_API

7: 29-DEC-94 A. Lower Created package
8: 06-23-95 A. Erickson cn_periods.period_name column name update
9: MAR-02-99 H. Chen code changes for MLS
10:
11: Name : CN_LEDGER_JOURNAL_ENTRIES_API
12: Purpose : Holds functions for accessing and procedures for setting
13: properties of journal entries.
14:
15: Notes :

Line 38: INSERT INTO cn_ledger_journal_entries

34: JE_Return NUMBER;
35:
36: BEGIN
37:
38: INSERT INTO cn_ledger_journal_entries
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,

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 85: INSERT INTO cn_ledger_journal_entries

81: --dbms_output.put_line('Credit: ' || x_credit_type_id);
82: --dbms_output.put_line('Role: ' || x_role_id);
83: --dbms_output.put_line('Batch: ' || x_batch_id);
84:
85: INSERT INTO cn_ledger_journal_entries
86: (batch_id,
87: srp_period_id,
88: balance_id,
89: credit,

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 139: INSERT INTO cn_ledger_journal_entries

135: JE_Return NUMBER;
136:
137: BEGIN
138:
139: INSERT INTO cn_ledger_journal_entries
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,

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;

Line 222: END CN_LEDGER_JOURNAL_ENTRIES_API;

218:
219: END Names_From_IDs;
220:
221:
222: END CN_LEDGER_JOURNAL_ENTRIES_API;