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.HZ_PARTY_STAGE_SHADOW dependencies on HZ_STAGE_MAP_TRANSFORM_SHADOW

Line 273: HZ_GEN_PLSQL.new('HZ_STAGE_MAP_TRANSFORM_SHADOW', 'PACKAGE BODY');

269:
270:
271: PROCEDURE generate_map_pkg_nolog IS
272: BEGIN
273: HZ_GEN_PLSQL.new('HZ_STAGE_MAP_TRANSFORM_SHADOW', 'PACKAGE BODY');
274: l('CREATE OR REPLACE PACKAGE BODY HZ_STAGE_MAP_TRANSFORM_SHADOW AS');
275:
276: generate_declarations;
277: generate_uds_proc;

Line 274: l('CREATE OR REPLACE PACKAGE BODY HZ_STAGE_MAP_TRANSFORM_SHADOW AS');

270:
271: PROCEDURE generate_map_pkg_nolog IS
272: BEGIN
273: HZ_GEN_PLSQL.new('HZ_STAGE_MAP_TRANSFORM_SHADOW', 'PACKAGE BODY');
274: l('CREATE OR REPLACE PACKAGE BODY HZ_STAGE_MAP_TRANSFORM_SHADOW AS');
275:
276: generate_declarations;
277: generate_uds_proc;
278: generate_party_query_proc;

Line 396: log('Generating package body for HZ_STAGE_MAP_TRANSFORM_SHADOW');

392: PROCEDURE generate_map_pkg IS
393: BEGIN
394: log('------------------------------------------------');
395: log('Calling generate_map_pkg');
396: log('Generating package body for HZ_STAGE_MAP_TRANSFORM_SHADOW');
397: HZ_GEN_PLSQL.new('HZ_STAGE_MAP_TRANSFORM_SHADOW', 'PACKAGE BODY');
398: l('CREATE OR REPLACE PACKAGE BODY HZ_STAGE_MAP_TRANSFORM_SHADOW AS');
399:
400: generate_declarations;

Line 397: HZ_GEN_PLSQL.new('HZ_STAGE_MAP_TRANSFORM_SHADOW', 'PACKAGE BODY');

393: BEGIN
394: log('------------------------------------------------');
395: log('Calling generate_map_pkg');
396: log('Generating package body for HZ_STAGE_MAP_TRANSFORM_SHADOW');
397: HZ_GEN_PLSQL.new('HZ_STAGE_MAP_TRANSFORM_SHADOW', 'PACKAGE BODY');
398: l('CREATE OR REPLACE PACKAGE BODY HZ_STAGE_MAP_TRANSFORM_SHADOW AS');
399:
400: generate_declarations;
401: generate_uds_proc;

Line 398: l('CREATE OR REPLACE PACKAGE BODY HZ_STAGE_MAP_TRANSFORM_SHADOW AS');

394: log('------------------------------------------------');
395: log('Calling generate_map_pkg');
396: log('Generating package body for HZ_STAGE_MAP_TRANSFORM_SHADOW');
397: HZ_GEN_PLSQL.new('HZ_STAGE_MAP_TRANSFORM_SHADOW', 'PACKAGE BODY');
398: l('CREATE OR REPLACE PACKAGE BODY HZ_STAGE_MAP_TRANSFORM_SHADOW AS');
399:
400: generate_declarations;
401: generate_uds_proc;
402: generate_party_query_proc;

Line 449: ctx_ddl.set_attribute( 'hz_party_uds', 'procedure', 'HZ_STAGE_MAP_TRANSFORM_SHADOW.party_ds');

445:
446: begin
447: log('Creating user data store preferences for PARTY');
448: ctx_ddl.create_preference('hz_party_uds', 'user_datastore');
449: ctx_ddl.set_attribute( 'hz_party_uds', 'procedure', 'HZ_STAGE_MAP_TRANSFORM_SHADOW.party_ds');
450: ctx_ddl.set_attribute( 'hz_party_uds', 'output_type', 'CLOB');
451:
452: log('Creating user data store preferences for PARTY SITE');
453: ctx_ddl.create_preference('hz_party_site_uds', 'user_datastore');

Line 454: ctx_ddl.set_attribute('hz_party_site_uds', 'procedure', 'HZ_STAGE_MAP_TRANSFORM_SHADOW.party_site_ds');

450: ctx_ddl.set_attribute( 'hz_party_uds', 'output_type', 'CLOB');
451:
452: log('Creating user data store preferences for PARTY SITE');
453: ctx_ddl.create_preference('hz_party_site_uds', 'user_datastore');
454: ctx_ddl.set_attribute('hz_party_site_uds', 'procedure', 'HZ_STAGE_MAP_TRANSFORM_SHADOW.party_site_ds');
455: ctx_ddl.set_attribute('hz_party_site_uds', 'output_type', 'CLOB');
456:
457: log('Creating user data store preferences for CONTACT');
458: ctx_ddl.create_preference('hz_contact_uds', 'user_datastore');

Line 459: ctx_ddl.set_attribute('hz_contact_uds', 'procedure', 'HZ_STAGE_MAP_TRANSFORM_SHADOW.contact_ds');

455: ctx_ddl.set_attribute('hz_party_site_uds', 'output_type', 'CLOB');
456:
457: log('Creating user data store preferences for CONTACT');
458: ctx_ddl.create_preference('hz_contact_uds', 'user_datastore');
459: ctx_ddl.set_attribute('hz_contact_uds', 'procedure', 'HZ_STAGE_MAP_TRANSFORM_SHADOW.contact_ds');
460: ctx_ddl.set_attribute('hz_contact_uds', 'output_type', 'CLOB');
461:
462: log('Creating user data store preferences for CONTACT POINT');
463: ctx_ddl.create_preference('hz_contact_point_uds', 'user_datastore');

Line 464: ctx_ddl.set_attribute('hz_contact_point_uds', 'procedure', 'HZ_STAGE_MAP_TRANSFORM_SHADOW.contact_point_ds');

460: ctx_ddl.set_attribute('hz_contact_uds', 'output_type', 'CLOB');
461:
462: log('Creating user data store preferences for CONTACT POINT');
463: ctx_ddl.create_preference('hz_contact_point_uds', 'user_datastore');
464: ctx_ddl.set_attribute('hz_contact_point_uds', 'procedure', 'HZ_STAGE_MAP_TRANSFORM_SHADOW.contact_point_ds');
465: ctx_ddl.set_attribute('hz_contact_point_uds', 'output_type', 'CLOB');
466:
467:
468:

Line 1013: -- Generate the procedures in HZ_STAGE_MAP_TRANSFORM_SHADOW, which will be eventually used by the

1009: -- Create preferences for section groups
1010: create_section_group_prefs ;
1011: -- Create preferences for user data store
1012: create_uds_prefs ;
1013: -- Generate the procedures in HZ_STAGE_MAP_TRANSFORM_SHADOW, which will be eventually used by the
1014: -- Data Workers, to stage Data.
1015: generate_map_pkg;
1016: end if;
1017:

Line 1497: HZ_STAGE_MAP_TRANSFORM_SHADOW.open_party_cursor(

1493: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
1494: COMMIT;
1495: log(' Regular Flow -- Fresh Run of Staging');
1496: HZ_TRANS_PKG.set_party_type('ORGANIZATION');
1497: HZ_STAGE_MAP_TRANSFORM_SHADOW.open_party_cursor(
1498: 'ALL_PARTIES', 'ORGANIZATION',l_worker_number, l_num_workers, NULL,'N', l_party_cur);
1499: HZ_STAGE_MAP_TRANSFORM_SHADOW.insert_stage_parties('N',l_party_cur);
1500: ELSE
1501: HZ_TRANS_PKG.set_party_type('ORGANIZATION');

Line 1499: HZ_STAGE_MAP_TRANSFORM_SHADOW.insert_stage_parties('N',l_party_cur);

1495: log(' Regular Flow -- Fresh Run of Staging');
1496: HZ_TRANS_PKG.set_party_type('ORGANIZATION');
1497: HZ_STAGE_MAP_TRANSFORM_SHADOW.open_party_cursor(
1498: 'ALL_PARTIES', 'ORGANIZATION',l_worker_number, l_num_workers, NULL,'N', l_party_cur);
1499: HZ_STAGE_MAP_TRANSFORM_SHADOW.insert_stage_parties('N',l_party_cur);
1500: ELSE
1501: HZ_TRANS_PKG.set_party_type('ORGANIZATION');
1502: log(' Continue for Org cursor');
1503: HZ_STAGE_MAP_TRANSFORM_SHADOW.open_party_cursor(

Line 1503: HZ_STAGE_MAP_TRANSFORM_SHADOW.open_party_cursor(

1499: HZ_STAGE_MAP_TRANSFORM_SHADOW.insert_stage_parties('N',l_party_cur);
1500: ELSE
1501: HZ_TRANS_PKG.set_party_type('ORGANIZATION');
1502: log(' Continue for Org cursor');
1503: HZ_STAGE_MAP_TRANSFORM_SHADOW.open_party_cursor(
1504: 'ALL_PARTIES', 'ORGANIZATION',l_worker_number, l_num_workers, NULL,'Y', l_party_cur);
1505: HZ_STAGE_MAP_TRANSFORM_SHADOW.insert_stage_parties('Y',l_party_cur);
1506: END IF;
1507:

Line 1505: HZ_STAGE_MAP_TRANSFORM_SHADOW.insert_stage_parties('Y',l_party_cur);

1501: HZ_TRANS_PKG.set_party_type('ORGANIZATION');
1502: log(' Continue for Org cursor');
1503: HZ_STAGE_MAP_TRANSFORM_SHADOW.open_party_cursor(
1504: 'ALL_PARTIES', 'ORGANIZATION',l_worker_number, l_num_workers, NULL,'Y', l_party_cur);
1505: HZ_STAGE_MAP_TRANSFORM_SHADOW.insert_stage_parties('Y',l_party_cur);
1506: END IF;
1507:
1508: CLOSE l_party_cur;
1509: l_log_step := 'SHADOW_STEP1';

Line 1539: HZ_STAGE_MAP_TRANSFORM_SHADOW.open_party_cursor(

1535: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
1536: COMMIT;
1537: log(' Regular Flow -- Fresh Run of Staging');
1538: HZ_TRANS_PKG.set_party_type('PERSON');
1539: HZ_STAGE_MAP_TRANSFORM_SHADOW.open_party_cursor(
1540: 'ALL_PARTIES', 'PERSON',l_worker_number, l_num_workers, NULL,'N', l_party_cur);
1541: HZ_STAGE_MAP_TRANSFORM_SHADOW.insert_stage_parties('N',l_party_cur);
1542: ELSE
1543: log(' Continue for Per cursor');

Line 1541: HZ_STAGE_MAP_TRANSFORM_SHADOW.insert_stage_parties('N',l_party_cur);

1537: log(' Regular Flow -- Fresh Run of Staging');
1538: HZ_TRANS_PKG.set_party_type('PERSON');
1539: HZ_STAGE_MAP_TRANSFORM_SHADOW.open_party_cursor(
1540: 'ALL_PARTIES', 'PERSON',l_worker_number, l_num_workers, NULL,'N', l_party_cur);
1541: HZ_STAGE_MAP_TRANSFORM_SHADOW.insert_stage_parties('N',l_party_cur);
1542: ELSE
1543: log(' Continue for Per cursor');
1544: HZ_TRANS_PKG.set_party_type('PERSON');
1545: HZ_STAGE_MAP_TRANSFORM_SHADOW.open_party_cursor(

Line 1545: HZ_STAGE_MAP_TRANSFORM_SHADOW.open_party_cursor(

1541: HZ_STAGE_MAP_TRANSFORM_SHADOW.insert_stage_parties('N',l_party_cur);
1542: ELSE
1543: log(' Continue for Per cursor');
1544: HZ_TRANS_PKG.set_party_type('PERSON');
1545: HZ_STAGE_MAP_TRANSFORM_SHADOW.open_party_cursor(
1546: 'ALL_PARTIES', 'PERSON',l_worker_number, l_num_workers, NULL,'Y', l_party_cur);
1547: HZ_STAGE_MAP_TRANSFORM_SHADOW.insert_stage_parties('Y',l_party_cur);
1548: END IF;
1549:

Line 1547: HZ_STAGE_MAP_TRANSFORM_SHADOW.insert_stage_parties('Y',l_party_cur);

1543: log(' Continue for Per cursor');
1544: HZ_TRANS_PKG.set_party_type('PERSON');
1545: HZ_STAGE_MAP_TRANSFORM_SHADOW.open_party_cursor(
1546: 'ALL_PARTIES', 'PERSON',l_worker_number, l_num_workers, NULL,'Y', l_party_cur);
1547: HZ_STAGE_MAP_TRANSFORM_SHADOW.insert_stage_parties('Y',l_party_cur);
1548: END IF;
1549:
1550: CLOSE l_party_cur;
1551: l_log_step := 'SHADOW_STEP2';

Line 1581: HZ_STAGE_MAP_TRANSFORM_SHADOW.open_party_cursor(

1577: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
1578: COMMIT;
1579: log(' Regular Flow -- Fresh Run of Staging');
1580: HZ_TRANS_PKG.set_party_type('OTHER');
1581: HZ_STAGE_MAP_TRANSFORM_SHADOW.open_party_cursor(
1582: 'ALL_PARTIES', 'OTHER',l_worker_number, l_num_workers, NULL,'N', l_party_cur);
1583: HZ_STAGE_MAP_TRANSFORM_SHADOW.insert_stage_parties('N',l_party_cur);
1584: ELSE
1585: log(' Continue for Oth cursor');

Line 1583: HZ_STAGE_MAP_TRANSFORM_SHADOW.insert_stage_parties('N',l_party_cur);

1579: log(' Regular Flow -- Fresh Run of Staging');
1580: HZ_TRANS_PKG.set_party_type('OTHER');
1581: HZ_STAGE_MAP_TRANSFORM_SHADOW.open_party_cursor(
1582: 'ALL_PARTIES', 'OTHER',l_worker_number, l_num_workers, NULL,'N', l_party_cur);
1583: HZ_STAGE_MAP_TRANSFORM_SHADOW.insert_stage_parties('N',l_party_cur);
1584: ELSE
1585: log(' Continue for Oth cursor');
1586: HZ_TRANS_PKG.set_party_type('OTHER');
1587: HZ_STAGE_MAP_TRANSFORM_SHADOW.open_party_cursor(

Line 1587: HZ_STAGE_MAP_TRANSFORM_SHADOW.open_party_cursor(

1583: HZ_STAGE_MAP_TRANSFORM_SHADOW.insert_stage_parties('N',l_party_cur);
1584: ELSE
1585: log(' Continue for Oth cursor');
1586: HZ_TRANS_PKG.set_party_type('OTHER');
1587: HZ_STAGE_MAP_TRANSFORM_SHADOW.open_party_cursor(
1588: 'ALL_PARTIES', 'OTHER',l_worker_number, l_num_workers, NULL,'Y', l_party_cur);
1589: HZ_STAGE_MAP_TRANSFORM_SHADOW.insert_stage_parties('Y',l_party_cur);
1590: END IF;
1591:

Line 1589: HZ_STAGE_MAP_TRANSFORM_SHADOW.insert_stage_parties('Y',l_party_cur);

1585: log(' Continue for Oth cursor');
1586: HZ_TRANS_PKG.set_party_type('OTHER');
1587: HZ_STAGE_MAP_TRANSFORM_SHADOW.open_party_cursor(
1588: 'ALL_PARTIES', 'OTHER',l_worker_number, l_num_workers, NULL,'Y', l_party_cur);
1589: HZ_STAGE_MAP_TRANSFORM_SHADOW.insert_stage_parties('Y',l_party_cur);
1590: END IF;
1591:
1592: CLOSE l_party_cur;
1593: l_log_step := 'SHADOW_STEP3';