DBA Data[Home] [Help]

APPS.FA_SLA_EVENTS_UPG_PKG dependencies on XLA_AE_LINES

Line 977: -- Business Rules for xla_ae_lines

973: c_application_id, -- upg_souce_application_id
974: null -- upg_valid_flag
975: );
976:
977: -- Business Rules for xla_ae_lines
978: -- * gl_transfer_mode_code:
979: -- D: Detailed mode when transferred to GL
980: -- S: Summary mode when transferred to GL
981: -- * gl_sl_link_table must be XLAJEL

Line 986: insert into xla_ae_lines (

982: -- * currency_conversion_* needs to be populated only if
983: -- different from ledger currency
984:
985: forall j IN 1..l_xla_gl_sl_link_id_tbl.count
986: insert into xla_ae_lines (
987: upg_batch_id,
988: ae_header_id,
989: ae_line_num,
990: displayed_line_number,

Line 1389: -- Business Rules for xla_ae_lines

1385: c_application_id, -- upg_souce_application_id
1386: null -- upg_valid_flag
1387: );
1388:
1389: -- Business Rules for xla_ae_lines
1390: -- * gl_transfer_mode_code:
1391: -- D: Detailed mode when transferred to GL
1392: -- S: Summary mode when transferred to GL
1393: -- * gl_sl_link_table must be XLAJEL

Line 1398: insert into xla_ae_lines (

1394: -- * currency_conversion_* needs to be populated only if
1395: -- different from ledger currency
1396:
1397: forall j IN 1..l_xla_gl_sl_link_id_tbl.count
1398: insert into xla_ae_lines (
1399: upg_batch_id,
1400: ae_header_id,
1401: ae_line_num,
1402: displayed_line_number,

Line 1681: -- Business Rules for xla_ae_lines

1677: select xla_ae_headers_s.nextval
1678: into l_ae_header_id
1679: from dual;
1680:
1681: -- Business Rules for xla_ae_lines
1682: -- * gl_transfer_mode_code:
1683: -- D: Detailed mode when transferred to GL
1684: -- S: Summary mode when transferred to GL
1685: -- * gl_sl_link_table must be XLAJEL

Line 1690: insert into xla_ae_lines (

1686: -- * currency_conversion_* needs to be populated only if
1687: -- different from ledger currency
1688:
1689: forall j IN 1..l_xla_gl_sl_link_id_tbl.count
1690: insert into xla_ae_lines (
1691: upg_batch_id,
1692: ae_header_id,
1693: ae_line_num,
1694: displayed_line_number,

Line 2093: -- Business Rules for xla_ae_lines

2089: c_application_id, -- upg_souce_application_id
2090: null -- upg_valid_flag
2091: );
2092:
2093: -- Business Rules for xla_ae_lines
2094: -- * gl_transfer_mode_code:
2095: -- D: Detailed mode when transferred to GL
2096: -- S: Summary mode when transferred to GL
2097: -- * gl_sl_link_table must be XLAJEL

Line 2102: insert into xla_ae_lines (

2098: -- * currency_conversion_* needs to be populated only if
2099: -- different from ledger currency
2100:
2101: forall j IN 1..l_xla_gl_sl_link_id_tbl.count
2102: insert into xla_ae_lines (
2103: upg_batch_id,
2104: ae_header_id,
2105: ae_line_num,
2106: displayed_line_number,

Line 3436: -- Business Rules for xla_ae_lines

3432: c_application_id, -- upg_souce_application_id
3433: null -- upg_valid_flag
3434: );
3435:
3436: -- Business Rules for xla_ae_lines
3437: -- * gl_transfer_mode_code:
3438: -- D: Detailed mode when transferred to GL
3439: -- S: Summary mode when transferred to GL
3440: -- * gl_sl_link_table must be XLAJEL

Line 3445: insert into xla_ae_lines (

3441: -- * currency_conversion_* needs to be populated only if
3442: -- different from ledger currency
3443:
3444: forall j IN 1..l_xla_gl_sl_link_id_tbl.count
3445: insert into xla_ae_lines (
3446: upg_batch_id,
3447: ae_header_id,
3448: ae_line_num,
3449: displayed_line_number,

Line 3848: -- Business Rules for xla_ae_lines

3844: c_application_id, -- upg_souce_application_id
3845: null -- upg_valid_flag
3846: );
3847:
3848: -- Business Rules for xla_ae_lines
3849: -- * gl_transfer_mode_code:
3850: -- D: Detailed mode when transferred to GL
3851: -- S: Summary mode when transferred to GL
3852: -- * gl_sl_link_table must be XLAJEL

Line 3857: insert into xla_ae_lines (

3853: -- * currency_conversion_* needs to be populated only if
3854: -- different from ledger currency
3855:
3856: forall j IN 1..l_xla_gl_sl_link_id_tbl.count
3857: insert into xla_ae_lines (
3858: upg_batch_id,
3859: ae_header_id,
3860: ae_line_num,
3861: displayed_line_number,

Line 4665: into xla_ae_lines (

4661: where th.rowid between p_start_rowid and p_end_rowid;
4662:
4663: insert all
4664: when (adj_row = 1) then
4665: into xla_ae_lines (
4666: upg_batch_id,
4667: ae_header_id,
4668: ae_line_num,
4669: displayed_line_number,

Line 4878: into xla_ae_lines (

4874: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id
4875: 'XLAJEL' -- gl_sl_link_table
4876: )
4877: when (adj_row = 2) then
4878: into xla_ae_lines (
4879: upg_batch_id,
4880: ae_header_id,
4881: ae_line_num,
4882: displayed_line_number,

Line 5093: into xla_ae_lines (

5089: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id
5090: 'XLAJEL' -- gl_sl_link_table
5091: )
5092: when (adj_row = 3) then
5093: into xla_ae_lines (
5094: upg_batch_id,
5095: ae_header_id,
5096: ae_line_num,
5097: displayed_line_number,

Line 5583: into xla_ae_lines (

5579: and mc.enabled_flag = 'Y';
5580:
5581: insert all
5582: when (adj_row = 1) then
5583: into xla_ae_lines (
5584: upg_batch_id,
5585: ae_header_id,
5586: ae_line_num,
5587: displayed_line_number,

Line 5796: into xla_ae_lines (

5792: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id
5793: 'XLAJEL' -- gl_sl_link_table
5794: )
5795: when (adj_row = 2) then
5796: into xla_ae_lines (
5797: upg_batch_id,
5798: ae_header_id,
5799: ae_line_num,
5800: displayed_line_number,

Line 6011: into xla_ae_lines (

6007: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id
6008: 'XLAJEL' -- gl_sl_link_table
6009: )
6010: when (adj_row = 3) then
6011: into xla_ae_lines (
6012: upg_batch_id,
6013: ae_header_id,
6014: ae_line_num,
6015: displayed_line_number,

Line 7209: into xla_ae_lines (

7205: end if;
7206:
7207: insert all
7208: when (1 = 1) then
7209: into xla_ae_lines (
7210: upg_batch_id,
7211: ae_header_id,
7212: ae_line_num,
7213: displayed_line_number,

Line 7725: into xla_ae_lines (

7721: and mc.enabled_flag = 'Y';
7722:
7723: insert all
7724: when (1 = 1) then
7725: into xla_ae_lines (
7726: upg_batch_id,
7727: ae_header_id,
7728: ae_line_num,
7729: displayed_line_number,

Line 8732: -- Business Rules for xla_ae_lines

8728: c_application_id, -- upg_souce_application_id
8729: null -- upg_valid_flag
8730: );
8731:
8732: -- Business Rules for xla_ae_lines
8733: -- * gl_transfer_mode_code:
8734: -- D: Detailed mode when transferred to GL
8735: -- S: Summary mode when transferred to GL
8736: -- * gl_sl_link_table must be XLAJEL

Line 8741: insert into xla_ae_lines (

8737: -- * currency_conversion_* needs to be populated only if different from
8738: -- ledger currency
8739:
8740: FORALL j IN 1..l_distribution_id_tbl.count
8741: insert into xla_ae_lines (
8742: upg_batch_id,
8743: ae_header_id,
8744: ae_line_num,
8745: displayed_line_number,

Line 8832: insert into xla_ae_lines (

8828: l_set_of_books_id_tbl(i) -- ledger_id/sob_id
8829: );
8830:
8831: FORALL j IN 1..l_distribution_id_tbl.count
8832: insert into xla_ae_lines (
8833: upg_batch_id,
8834: ae_header_id,
8835: ae_line_num,
8836: displayed_line_number,

Line 9367: -- Business Rules for xla_ae_lines

9363: c_application_id, -- upg_souce_application_id
9364: null -- upg_valid_flag
9365: );
9366:
9367: -- Business Rules for xla_ae_lines
9368: -- * gl_transfer_mode_code:
9369: -- D: Detailed mode when transferred to GL
9370: -- S: Summary mode when transferred to GL
9371: -- * gl_sl_link_table must be XLAJEL

Line 9376: insert into xla_ae_lines (

9372: -- * currency_conversion_* needs to be populated only if different from
9373: -- ledger currency
9374:
9375: FORALL j IN 1..l_distribution_id_tbl.count
9376: insert into xla_ae_lines (
9377: upg_batch_id,
9378: ae_header_id,
9379: ae_line_num,
9380: displayed_line_number,

Line 9467: insert into xla_ae_lines (

9463: l_rep_set_of_books_id_tbl(k) -- ledger_id/sob_id
9464: );
9465:
9466: FORALL j IN 1..l_distribution_id_tbl.count
9467: insert into xla_ae_lines (
9468: upg_batch_id,
9469: ae_header_id,
9470: ae_line_num,
9471: displayed_line_number,