APPS.HZ_PARTY_STAGE_SHADOW dependencies on DUAL

Line 1470: SELECT SYSDATE INTO l_startdate FROM DUAL;

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');
1473:
1474: OPEN l_log_cur(p_command, l_worker_number, 'SHADOW_STEP1');

Line 3778: l(' FROM DUAL WHERE H_R_PARTY_ID(I) IS NOT NULL;');

3774: l(' END LOOP; ');
3775: l(' FORALL I in H_C_PARTY_ID.FIRST..H_C_PARTY_ID.LAST ');
3776: l(' INSERT INTO HZ_DQM_STAGE_GT(PARTY_ID,OWNER_ID,ORG_CONTACT_ID,PARTY_INDEX, PERSON_PARTY_ID) ');
3777: l(' SELECT H_C_PARTY_ID(I), H_R_PARTY_ID(I), H_ORG_CONTACT_ID(I), H_PARTY_INDEX(I), H_PERSON_PARTY_ID(I)');
3778: l(' FROM DUAL WHERE H_R_PARTY_ID(I) IS NOT NULL;');
3779: l(' IF l_last_fetch THEN');
3780: l(' EXIT;');
3781: l(' END IF;');
3782: l(' END LOOP;');

Line 4442: '(:attrval,:lang,:attr,:entity,:ctx) from dual';

4438:
4439: BEGIN
4440: c := dbms_sql.open_cursor;
4441: l_sql := 'select ' || proc ||
4442: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
4443: dbms_sql.parse(c,l_sql,2);
4444: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
4445: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
4446: DBMS_SQL.BIND_VARIABLE(c,':attr','x');

Line 4471: '(:record_id,:entity,:attr,:ctx) from dual';

4467:
4468: BEGIN
4469: c := dbms_sql.open_cursor;
4470: l_sql := 'select ' || proc ||
4471: '(:record_id,:entity,:attr,:ctx) from dual';
4472: dbms_sql.parse(c,l_sql,2);
4473: DBMS_SQL.BIND_VARIABLE(c,':record_id','x');
4474: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
4475: DBMS_SQL.BIND_VARIABLE(c,':attr','x');

Line 4512: '(:attrval,:lang,:attr,:entity) from dual';

4508: l_procedure := FUNCS.PROCEDURE_NAME;
4509: l_trans_name := FUNCS.TRANSFORMATION_NAME;
4510: c := dbms_sql.open_cursor;
4511: l_sql := 'select ' || FUNCS.PROCEDURE_NAME ||
4512: '(:attrval,:lang,:attr,:entity) from dual';
4513: dbms_sql.parse(c,l_sql,2);
4514: dbms_sql.close_cursor(c);
4515: EXCEPTION WHEN OTHERS THEN
4516: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANS_PROC_ERROR1');

Line 4539: '(:record_id,:entity,:attr) from dual';

4535: l_attribute := FUNCS.ATTRIBUTE_NAME;
4536: l_procedure := FUNCS.custom_attribute_procedure;
4537: c := dbms_sql.open_cursor;
4538: l_sql := 'select ' || FUNCS.custom_attribute_procedure ||
4539: '(:record_id,:entity,:attr) from dual';
4540: dbms_sql.parse(c,l_sql,2);
4541: dbms_sql.close_cursor(c);
4542: EXCEPTION WHEN OTHERS THEN
4543: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR1');