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.

[Home] [Help]

APPS.GCS_INTERCO_DYNAMIC_PKG dependencies on GCS_ENTRY_LINES_GT

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 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 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 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: