DBA Data[Home] [Help]

APPS.AMW_SCOPE_PVT dependencies on AMW_AP_ASSOCIATIONS_S

Line 1886: SELECT AMW_AP_ASSOCIATIONS_S.nextval,

1882: pk3,
1883: pk4,
1884: object_type,
1885: object_version_number)
1886: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
1887: SYSDATE,
1888: FND_GLOBAL.USER_ID,
1889: SYSDATE,
1890: FND_GLOBAL.USER_ID,

Line 1959: SELECT AMW_AP_ASSOCIATIONS_S.nextval,

1955: pk3,
1956: pk4,
1957: object_type,
1958: object_version_number)
1959: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
1960: SYSDATE,
1961: FND_GLOBAL.USER_ID,
1962: SYSDATE,
1963: FND_GLOBAL.USER_ID,

Line 2031: SELECT AMW_AP_ASSOCIATIONS_S.nextval,

2027: pk3,
2028: pk4,
2029: object_type,
2030: object_version_number)
2031: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
2032: sysdate,
2033: fnd_global.user_id,
2034: sysdate,
2035: fnd_global.user_id,

Line 2283: SELECT AMW_AP_ASSOCIATIONS_S.nextval,

2279: pk3,
2280: pk4,
2281: object_type,
2282: object_version_number)
2283: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
2284: SYSDATE,
2285: FND_GLOBAL.USER_ID,
2286: SYSDATE,
2287: FND_GLOBAL.USER_ID,

Line 2354: SELECT AMW_AP_ASSOCIATIONS_S.nextval,

2350: pk3,
2351: pk4,
2352: object_type,
2353: object_version_number)
2354: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
2355: SYSDATE,
2356: FND_GLOBAL.USER_ID,
2357: SYSDATE,
2358: FND_GLOBAL.USER_ID,

Line 2424: SELECT AMW_AP_ASSOCIATIONS_S.nextval,

2420: pk3,
2421: pk4,
2422: object_type,
2423: object_version_number)
2424: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
2425: sysdate,
2426: fnd_global.user_id,
2427: sysdate,
2428: fnd_global.user_id,

Line 2486: UPDATE AMW_AP_ASSOCIATIONS SET object_type='PROJECT' WHERE object_type = 'PROJECT_NEW';

2482:
2483: END LOOP; -- end of FOR aapdetails_rec IN c_apdetails LOOP
2484:
2485: -- Change entity_type 'PROJECT_NEW' to 'PROJECT'
2486: UPDATE AMW_AP_ASSOCIATIONS SET object_type='PROJECT' WHERE object_type = 'PROJECT_NEW';
2487: --- Copy Attachment ends here
2488:
2489: FOR ap_attachment_rec IN c_ap_attachments LOOP
2490: -- Delete all the attachments for the audit procedure that is not present in the project

Line 2883: SELECT AMW_AP_ASSOCIATIONS_S.nextval,

2879: pk2,
2880: pk3,
2881: object_type,
2882: object_version_number)
2883: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
2884: sysdate,
2885: fnd_global.user_id,
2886: sysdate,
2887: fnd_global.user_id,

Line 3073: SELECT AMW_AP_ASSOCIATIONS_S.nextval,

3069: pk2,
3070: pk3,
3071: object_type,
3072: object_version_number)
3073: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
3074: sysdate,
3075: fnd_global.user_id,
3076: sysdate,
3077: fnd_global.user_id,