DBA Data[Home] [Help]

APPS.HZ_PARTY_STAGE_SHADOW dependencies on HZ_TRANS_PKG

Line 1468: HZ_TRANS_PKG.set_staging_context('Y');

1464: log('');
1465: log('Stage Parties begin');
1466:
1467: FND_MSG_PUB.initialize;
1468: HZ_TRANS_PKG.set_staging_context('Y');
1469:
1470: SELECT SYSDATE INTO l_startdate FROM DUAL;
1471:
1472: log('Staging Organization Party Records');

Line 1496: HZ_TRANS_PKG.set_party_type('ORGANIZATION');

1492: WHERE OPERATION = p_command
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

Line 1501: 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(
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);

Line 1538: HZ_TRANS_PKG.set_party_type('PERSON');

1534: WHERE OPERATION = p_command
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

Line 1544: HZ_TRANS_PKG.set_party_type('PERSON');

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(
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;

Line 1580: HZ_TRANS_PKG.set_party_type('OTHER');

1576: WHERE OPERATION = p_command
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

Line 1586: HZ_TRANS_PKG.set_party_type('OTHER');

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(
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;

Line 2854: l(' HZ_TRANS_PKG.next_gen_dqm := ''Y'';');

2850:
2851: l(' HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec ('||l_cond_attrib_list(l_idx)||','||'H_TX'||l_idx||'(I));');
2852: l_idx := l_idx+1;
2853: END LOOP;
2854: l(' HZ_TRANS_PKG.next_gen_dqm := ''Y'';');
2855: l('');
2856:
2857:
2858: FOR I IN 1..255 LOOP

Line 3009: l(' HZ_TRANS_PKG.next_gen_dqm := ''Y'';');

3005:
3006: l(' HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec ('||l_cond_attrib_list(l_idx)||','||'H_TX'||l_idx||'(1));');
3007: l_idx := l_idx+1;
3008: END LOOP;
3009: l(' HZ_TRANS_PKG.next_gen_dqm := ''Y'';');
3010:
3011:
3012: FOR I IN 1..255 LOOP
3013: IF l_forall_list(I) <> 'N' THEN

Line 3298: l(' HZ_TRANS_PKG.next_gen_dqm := ''Y'';');

3294:
3295: l(' HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec ('||l_cond_attrib_list(l_idx)||','||'H_TX'||l_idx||'(I));');
3296: l_idx := l_idx+1;
3297: END LOOP;
3298: l(' HZ_TRANS_PKG.next_gen_dqm := ''Y'';');
3299:
3300: FOR I IN 1..255 LOOP
3301: IF l_forall_list(I) <> 'N' THEN
3302: IF l_custom_list(I) <> 'N' AND l_mincol_list(I) = 'Y' THEN

Line 3417: l(' HZ_TRANS_PKG.next_gen_dqm := ''Y'';');

3413:
3414: l(' HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec ('||l_cond_attrib_list(l_idx)||','||'H_TX'||l_idx||'(1));');
3415: l_idx := l_idx+1;
3416: END LOOP;
3417: l(' HZ_TRANS_PKG.next_gen_dqm := ''Y'';');
3418:
3419: FOR I IN 1..255 LOOP
3420: IF l_forall_list(I) <> 'N' THEN
3421: IF l_custom_list(I) <> 'N' AND l_mincol_list(I) = 'Y' THEN

Line 3715: l(' HZ_TRANS_PKG.next_gen_dqm := ''Y'';');

3711:
3712: l(' HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec ('||l_cond_attrib_list(l_idx)||','||'H_TX'||l_idx||'(I));');
3713: l_idx := l_idx+1;
3714: END LOOP;
3715: l(' HZ_TRANS_PKG.next_gen_dqm := ''Y'';');
3716:
3717: l('');
3718:
3719: FOR I IN 1..255 LOOP

Line 3838: l(' HZ_TRANS_PKG.next_gen_dqm := ''Y'';');

3834:
3835: l(' HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec ('||l_cond_attrib_list(l_idx)||','||'H_TX'||l_idx||'(1));');
3836: l_idx := l_idx+1;
3837: END LOOP;
3838: l(' HZ_TRANS_PKG.next_gen_dqm := ''Y'';');
3839: FOR I IN 1..255 LOOP
3840: IF l_forall_list(I) <> 'N' THEN
3841: IF l_custom_list(I) <> 'N' AND l_mincol_list(I) = 'Y' THEN
3842: l(' H_TX'||I||'(1):='||replace(l_custom_list(I),'(I)','(1)')||';');

Line 4135: l(' HZ_TRANS_PKG.next_gen_dqm := ''Y'';');

4131:
4132: l(' HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec ('||l_cond_attrib_list(l_idx)||','||'H_TX'||l_idx||'(I));');
4133: l_idx := l_idx+1;
4134: END LOOP;
4135: l(' HZ_TRANS_PKG.next_gen_dqm := ''Y'';');
4136: FOR I IN 1..255 LOOP
4137: IF l_forall_list(I) <> 'N' THEN
4138: IF l_custom_list(I) <> 'N' AND l_mincol_list(I) = 'Y' THEN
4139: l(' H_TX'||I||'(I):='||l_custom_list(I)||';');

Line 4245: l(' HZ_TRANS_PKG.next_gen_dqm := ''Y'';');

4241:
4242: l(' HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec ('||l_cond_attrib_list(l_idx)||','||'H_TX'||l_idx||'(1));');
4243: l_idx := l_idx+1;
4244: END LOOP;
4245: l(' HZ_TRANS_PKG.next_gen_dqm := ''Y'';');
4246:
4247: FOR I IN 1..255 LOOP
4248: IF l_forall_list(I) <> 'N' THEN
4249: IF l_custom_list(I) <> 'N' AND l_mincol_list(I) = 'Y' THEN