eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GCS_INTERCO_DYNAMIC_PKG dependencies on GCS_ENTRY_LINES

Line 35: -- GCS_ENTRY-LINES.

31:
32: l_api_name VARCHAR2(30) := 'INSR_INTERCO_LINES';
33:
34: -- Insert all eligible elimination lines from GCS_INTERCO_ELM_TRX
35: -- GCS_ENTRY-LINES.
36: BEGIN
37:
38: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
39: fnd_log.STRING (fnd_log.level_procedure,

Line 79: || ' into GCS_ENTRY_LINES_GT'

75: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
76: fnd_log.STRING (fnd_log.level_procedure,
77: g_pkg_name || '.' || l_api_name,
78: 'Intercompany- Inserting entry lines'
79: || ' into GCS_ENTRY_LINES_GT'
80: || ' after matching by company-Receivables side'
81: );
82: END IF;
83:

Line 85: INSERT INTO GCS_ENTRY_LINES_GT

81: );
82: END IF;
83:
84:
85: INSERT INTO GCS_ENTRY_LINES_GT
86: ( ENTRY_ID, COMPANY_COST_CENTER_ORG_ID
87: , LINE_ITEM_Id, INTERCOMPANY_ID, FINANCIAL_ELEM_ID
88: , PRODUCT_ID, NATURAL_ACCOUNT_ID, CHANNEL_ID
89: , PROJECT_ID, CUSTOMER_ID, TASK_ID, USER_DIM1_ID

Line 155: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');

151:
152: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
153: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
154: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
155: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
156:
157: FND_LOG.String (fnd_log.level_procedure,
158: g_pkg_name || '.' || l_api_name,
159: 'SHRD0117: '||FND_MESSAGE.get);

Line 168: || ' into GCS_ENTRY_LINES_GT'

164: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
165: fnd_log.STRING (fnd_log.level_procedure,
166: g_pkg_name || '.' || l_api_name,
167: 'Intercompany- Inserting entry lines'
168: || ' into GCS_ENTRY_LINES_GT'
169: || ' after matching by company - Payabales side'
170: );
171: END IF;
172:

Line 173: INSERT INTO GCS_ENTRY_LINES_GT

169: || ' after matching by company - Payabales side'
170: );
171: END IF;
172:
173: INSERT INTO GCS_ENTRY_LINES_GT
174: ( ENTRY_ID, COMPANY_COST_CENTER_ORG_ID
175: , LINE_ITEM_Id, INTERCOMPANY_ID, FINANCIAL_ELEM_ID
176: , PRODUCT_ID, NATURAL_ACCOUNT_ID, CHANNEL_ID
177: , PROJECT_ID, CUSTOMER_ID, TASK_ID, USER_DIM1_ID

Line 243: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');

239:
240: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
241: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
242: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
243: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
244:
245: FND_LOG.String (fnd_log.level_procedure,
246: g_pkg_name || '.' || l_api_name,
247: 'SHRD0117: '||FND_MESSAGE.get);

Line 260: || ' into GCS_ENTRY_LINES_GT'

256: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
257: fnd_log.STRING (fnd_log.level_procedure,
258: g_pkg_name || '.' || l_api_name,
259: 'Intercompany- Inserting entry lines'
260: || ' into GCS_ENTRY_LINES_GT'
261: || ' after matching by Org-Receivables side'
262: );
263: END IF;
264:

Line 265: INSERT INTO GCS_ENTRY_LINES_GT

261: || ' after matching by Org-Receivables side'
262: );
263: END IF;
264:
265: INSERT INTO GCS_ENTRY_LINES_GT
266: ( ENTRY_ID, COMPANY_COST_CENTER_ORG_ID
267: , LINE_ITEM_Id, INTERCOMPANY_ID, FINANCIAL_ELEM_ID
268: , PRODUCT_ID, NATURAL_ACCOUNT_ID, CHANNEL_ID
269: , PROJECT_ID, CUSTOMER_ID, TASK_ID, USER_DIM1_ID

Line 338: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');

334:
335: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
336: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
337: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
338: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
339:
340: FND_LOG.String (fnd_log.level_procedure,
341: g_pkg_name || '.' || l_api_name,
342: 'SHRD0117: '||FND_MESSAGE.get);

Line 351: || ' into GCS_ENTRY_LINES'

347: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
348: fnd_log.STRING (fnd_log.level_procedure,
349: g_pkg_name || '.' || l_api_name,
350: 'Intercompany- Inserting entry lines'
351: || ' into GCS_ENTRY_LINES'
352: || ' after matching by Org-Payables side'
353: );
354: END IF;
355:

Line 356: INSERT INTO GCS_ENTRY_LINES_GT

352: || ' after matching by Org-Payables side'
353: );
354: END IF;
355:
356: INSERT INTO GCS_ENTRY_LINES_GT
357: ( ENTRY_ID, COMPANY_COST_CENTER_ORG_ID
358: , LINE_ITEM_Id, INTERCOMPANY_ID, FINANCIAL_ELEM_ID
359: , PRODUCT_ID, NATURAL_ACCOUNT_ID, CHANNEL_ID
360: , PROJECT_ID, CUSTOMER_ID, TASK_ID, USER_DIM1_ID

Line 429: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');

425:
426: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
427: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
428: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
429: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
430:
431: FND_LOG.String (fnd_log.level_procedure,
432: g_pkg_name || '.' || l_api_name,
433: 'SHRD0117: '||FND_MESSAGE.get);

Line 444: || ' into GCS_ENTRY_LINES_GT'

440: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
441: fnd_log.STRING (fnd_log.level_procedure,
442: g_pkg_name || '.' || l_api_name,
443: 'Intracompany- Inserting entry lines'
444: || ' into GCS_ENTRY_LINES_GT'
445: || ' after matching by company'
446: );
447: END IF;
448:

Line 449: INSERT INTO GCS_ENTRY_LINES_GT

445: || ' after matching by company'
446: );
447: END IF;
448:
449: INSERT INTO GCS_ENTRY_LINES_GT
450: ( ENTRY_ID, COMPANY_COST_CENTER_ORG_ID
451: , LINE_ITEM_Id, INTERCOMPANY_ID, FINANCIAL_ELEM_ID
452: , PRODUCT_ID, NATURAL_ACCOUNT_ID, CHANNEL_ID
453: , PROJECT_ID, CUSTOMER_ID, TASK_ID, USER_DIM1_ID

Line 526: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');

522:
523: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
524: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
525: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
526: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
527:
528: FND_LOG.String (fnd_log.level_procedure,
529: g_pkg_name || '.' || l_api_name,
530: 'SHRD0117: '||FND_MESSAGE.get);

Line 542: || 'into GCS_ENTRY_LINES_GT'

538: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
539: fnd_log.STRING (fnd_log.level_procedure,
540: g_pkg_name || '.' || l_api_name,
541: 'Intracompany- Inserting entry lines'
542: || 'into GCS_ENTRY_LINES_GT'
543: || 'after matching by Org'
544: );
545: END IF;
546:

Line 547: INSERT INTO GCS_ENTRY_LINES_GT

543: || 'after matching by Org'
544: );
545: END IF;
546:
547: INSERT INTO GCS_ENTRY_LINES_GT
548: ( ENTRY_ID, COMPANY_COST_CENTER_ORG_ID
549: , LINE_ITEM_Id, INTERCOMPANY_ID, FINANCIAL_ELEM_ID
550: , PRODUCT_ID, NATURAL_ACCOUNT_ID, CHANNEL_ID
551: , PROJECT_ID, CUSTOMER_ID, TASK_ID, USER_DIM1_ID

Line 626: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');

622:
623: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
624: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
625: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
626: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
627:
628: FND_LOG.String (fnd_log.level_procedure,
629: g_pkg_name || '.' || l_api_name,
630: 'SHRD0117: '||FND_MESSAGE.get);

Line 668: -- into the GCS_ENTRY_LINES table.

664:
665: -- Purpose
666:
667: -- This routine is responsible for inserting the suspense plug in lines
668: -- into the GCS_ENTRY_LINES table.
669:
670: FUNCTION INSR_SUSPENSE_LINES (p_hierarchy_id IN NUMBER,
671: p_cal_period_id IN NUMBER,
672: p_entity_id IN NUMBER,

Line 685: -- into GCS_ENTRY-LINES.

681:
682: l_api_name VARCHAR2(30) := 'INSR_SUSPENSE_LINES';
683:
684: -- Insert Suspense lines for unbalanced matched rows
685: -- into GCS_ENTRY-LINES.
686: BEGIN
687:
688: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
689: fnd_log.STRING (fnd_log.level_procedure,

Line 725: || ' into GCS_ENTRY_LINES_GT'

721: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
722: fnd_log.STRING (fnd_log.level_procedure,
723: g_pkg_name || '.' || l_api_name,
724: 'Intercompany- Inserting necessary suspense lines'
725: || ' into GCS_ENTRY_LINES_GT'
726: || ' after matching by company'
727: );
728: END IF;
729:

Line 730: INSERT INTO GCS_ENTRY_LINES_GT

726: || ' after matching by company'
727: );
728: END IF;
729:
730: INSERT INTO GCS_ENTRY_LINES_GT
731: ( ENTRY_ID, COMPANY_COST_CENTER_ORG_ID
732: , FINANCIAL_ELEM_ID, LINE_ITEM_Id, INTERCOMPANY_ID
733: , PRODUCT_ID, NATURAL_ACCOUNT_ID, CHANNEL_ID
734: , PROJECT_ID, CUSTOMER_ID, TASK_ID, USER_DIM1_ID

Line 776: FROM GCS_ENTRY_LINES_GT gel,

772: SUM(NVL(ytd_credit_balance_e,0)), 0,
773: ABS(SUM(NVL(ytd_debit_balance_e,0))-
774: SUM(NVL(ytd_credit_balance_e,0)))))
775:
776: FROM GCS_ENTRY_LINES_GT gel,
777: GCS_INTERCO_HDR_GT gihg1,
778: fem_cctr_orgs_attr fcoa2 ,
779: fem_cctr_orgs_attr fcoa3
780: WHERE gihg1.entry_id = gel.entry_id

Line 800: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');

796:
797: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
798: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
799: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
800: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
801:
802: FND_LOG.String (fnd_log.level_procedure,
803: g_pkg_name || '.' || l_api_name,
804: 'SHRD0117: '||FND_MESSAGE.get);

Line 814: || ' into GCS_ENTRY_LINES_GT'

810: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
811: fnd_log.STRING (fnd_log.level_procedure,
812: g_pkg_name || '.' || l_api_name,
813: 'Intercompany- Inserting necessary suspense lines'
814: || ' into GCS_ENTRY_LINES_GT'
815: || ' after matching by org '
816: );
817: END IF;
818:

Line 819: INSERT INTO GCS_ENTRY_LINES_GT

815: || ' after matching by org '
816: );
817: END IF;
818:
819: INSERT INTO GCS_ENTRY_LINES_GT
820: ( ENTRY_ID, COMPANY_COST_CENTER_ORG_ID
821: , FINANCIAL_ELEM_ID, LINE_ITEM_Id, INTERCOMPANY_ID
822: , PRODUCT_ID, NATURAL_ACCOUNT_ID, CHANNEL_ID
823: , PROJECT_ID, CUSTOMER_ID, TASK_ID, USER_DIM1_ID

Line 862: FROM GCS_ENTRY_LINES_GT gel,

858: SUM(NVL(ytd_debit_balance_e,0))),
859: SUM(NVL(ytd_credit_balance_e,0)), 0,
860: ABS(SUM(NVL(ytd_debit_balance_e,0))-
861: SUM(NVL(ytd_credit_balance_e,0)))))
862: FROM GCS_ENTRY_LINES_GT gel,
863: GCS_INTERCO_HDR_GT gihg1
864: WHERE gihg1.entry_id = gel.entry_id
865: GROUP BY gihg1.entry_id, receivables_org_id, payables_org_id;
866:

Line 872: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');

868:
869: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
870: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
871: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
872: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
873:
874: FND_LOG.String (fnd_log.level_procedure,
875: g_pkg_name || '.' || l_api_name,
876: 'SHRD0117: '||FND_MESSAGE.get);

Line 887: || ' into GCS_ENTRY_LINES'

883: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
884: fnd_log.STRING (fnd_log.level_procedure,
885: g_pkg_name || '.' || l_api_name,
886: 'Intercompany- Inserting '
887: || ' into GCS_ENTRY_LINES'
888: || ' after processing'
889: );
890: END IF;
891:

Line 892: INSERT INTO GCS_ENTRY_LINES

888: || ' after processing'
889: );
890: END IF;
891:
892: INSERT INTO GCS_ENTRY_LINES
893: ( ENTRY_ID, COMPANY_COST_CENTER_ORG_ID
894: , FINANCIAL_ELEM_ID, LINE_ITEM_Id, INTERCOMPANY_ID
895: , PRODUCT_ID, NATURAL_ACCOUNT_ID, CHANNEL_ID
896: , PROJECT_ID, CUSTOMER_ID, TASK_ID, USER_DIM1_ID

Line 916: FROM GCS_ENTRY_LINES_GT

912: , YTD_DEBIT_BALANCE_E , YTD_CREDIT_BALANCE_E
913: , SYSDATE, g_fnd_user_id
914: , SYSDATE, g_fnd_user_id, g_fnd_login_id
915: , DESCRIPTION, YTD_BALANCE_E
916: FROM GCS_ENTRY_LINES_GT
917: WHERE DESCRIPTION <> 'SUSPENSE_LINE'
918:
919: UNION ALL
920: SELECT ENTRY_ID, COMPANY_COST_CENTER_ORG_ID

Line 931: FROM GCS_ENTRY_LINES_GT

927: , YTD_DEBIT_BALANCE_E , YTD_CREDIT_BALANCE_E
928: , SYSDATE, g_fnd_user_id
929: , SYSDATE, g_fnd_user_id, g_fnd_login_id
930: , DESCRIPTION, YTD_BALANCE_E
931: FROM GCS_ENTRY_LINES_GT
932: WHERE (DESCRIPTION = 'SUSPENSE_LINE' AND YTD_BALANCE_E <> 0);
933:
934: g_no_rows := NVL(SQL%ROWCOUNT,0);
935:

Line 939: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES');

935:
936: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
937: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
938: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
939: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES');
940:
941: FND_LOG.String (fnd_log.level_procedure,
942: g_pkg_name || '.' || l_api_name,
943: 'SHRD0117: '||FND_MESSAGE.get);

Line 1209: GCS_ENTRY_LINES gel,

1205: fcoa3.dim_attribute_numeric_member,
1206: fcoa2.dim_attribute_numeric_member,
1207: fcca.dim_attribute_numeric_member)
1208: FROM GCS_ENTRY_HEADERS geh,
1209: GCS_ENTRY_LINES gel,
1210: GCS_ENTITY_CCTR_ORGS geo,
1211: GCS_ENTITY_CCTR_ORGS geo1,
1212: GCS_CONS_RELATIONSHIPS gcr,
1213: GCS_CONS_RELATIONSHIPS gcr1,

Line 1352: GCS_ENTRY_LINES gel,

1348: fcoa3.dim_attribute_numeric_member,
1349: fcoa2.dim_attribute_numeric_member,
1350: fcca.dim_attribute_numeric_member)
1351: FROM GCS_ENTRY_HEADERS geh,
1352: GCS_ENTRY_LINES gel,
1353: GCS_ENTITY_CCTR_ORGS geo,
1354: GCS_ENTITY_CCTR_ORGS geo1,
1355: GCS_CONS_RELATIONSHIPS gcr,
1356: GCS_CONS_RELATIONSHIPS gcr1,

Line 1495: GCS_ENTRY_LINES gel,

1491: SYSDATE, g_fnd_user_id,
1492: SYSDATE, g_fnd_user_id,
1493: g_fnd_login_id
1494: FROM GCS_ENTRY_HEADERS geh,
1495: GCS_ENTRY_LINES gel,
1496: GCS_ENTITY_CCTR_ORGS geo,
1497: GCS_ENTITY_CCTR_ORGS geo1,
1498: GCS_CONS_RELATIONSHIPS gcr,
1499: GCS_CONS_RELATIONSHIPS gcr1

Line 1582: GCS_ENTRY_LINES gel,

1578: SYSDATE, g_fnd_user_id,
1579: SYSDATE, g_fnd_user_id,
1580: g_fnd_login_id
1581: FROM GCS_ENTRY_HEADERS geh,
1582: GCS_ENTRY_LINES gel,
1583: GCS_ENTITY_CCTR_ORGS geo,
1584: GCS_ENTITY_CCTR_ORGS geo1,
1585: GCS_CONS_RELATIONSHIPS gcr,
1586: GCS_CONS_RELATIONSHIPS gcr1

Line 1676: GCS_ENTRY_LINES gel,

1672: SYSDATE, g_fnd_user_id,
1673: SYSDATE, g_fnd_user_id,
1674: g_fnd_login_id
1675: FROM GCS_ENTRY_HEADERS geh,
1676: GCS_ENTRY_LINES gel,
1677: GCS_ENTITY_CCTR_ORGS geo,
1678: GCS_ENTITY_CCTR_ORGS geo1,
1679: GCS_CONS_RELATIONSHIPS gcr,
1680: GCS_CONS_RELATIONSHIPS gcr1,

Line 1788: GCS_ENTRY_LINES gel,

1784: SYSDATE, g_fnd_user_id,
1785: SYSDATE, g_fnd_user_id,
1786: g_fnd_login_id
1787: FROM GCS_ENTRY_HEADERS geh,
1788: GCS_ENTRY_LINES gel,
1789: GCS_ENTITY_CCTR_ORGS geo,
1790: GCS_ENTITY_CCTR_ORGS geo1,
1791: GCS_CONS_RELATIONSHIPS gcr,
1792: GCS_CONS_RELATIONSHIPS gcr1,