APPS.AMW_PARAMETERS_PVT_PKG dependencies on AMW_PROCESS_ORGANIZATION

Line 144: -- INSERT A NEW ROW IN TO THE AMW_PROCESS_ORGANIZATION..

140: p_pk4 => p_pk4,
141: p_pk5 => p_pk5);
142:
143:
144: -- INSERT A NEW ROW IN TO THE AMW_PROCESS_ORGANIZATION..
145: INSERT INTO AMW_PROCESS_ORGANIZATION(
146: PROCESS_ORGANIZATION_ID,
147: PROCESS_ID,
148: STANDARD_PROCESS_FLAG,

Line 145: INSERT INTO AMW_PROCESS_ORGANIZATION(

141: p_pk5 => p_pk5);
142:
143:
144: -- INSERT A NEW ROW IN TO THE AMW_PROCESS_ORGANIZATION..
145: INSERT INTO AMW_PROCESS_ORGANIZATION(
146: PROCESS_ORGANIZATION_ID,
147: PROCESS_ID,
148: STANDARD_PROCESS_FLAG,
149: APPROVAL_STATUS,

Line 164: values( AMW_PROCESS_ORGANIZATION_S.nextval,

160: CREATION_DATE,
161: LAST_UPDATED_BY,
162: LAST_UPDATE_DATE,
163: LAST_UPDATE_LOGIN)
164: values( AMW_PROCESS_ORGANIZATION_S.nextval,
165: -2,
166: 'Y',
167: 'A',
168: p_pk1,

Line 424: from amw_process_organization

420: cursor orgs_to_configure is
421: select organization_id
422: from amw_audit_units_v
423: where organization_id not in (select organization_id
424: from amw_process_organization
425: where process_id = -2 );
426:
427: -- when updating you need to skip those orgs in which processes are in pending approval.
428: cursor orgs_to_update is

Line 430: from amw_process_organization

426:
427: -- when updating you need to skip those orgs in which processes are in pending approval.
428: cursor orgs_to_update is
429: select organization_id
430: from amw_process_organization
431: where process_id = -2
432: and organization_id not in (select distinct organization_id
433: from amw_process_locks);
434:

Line 516: -- INSERT A NEW ROW IN TO THE AMW_PROCESS_ORGANIZATION..

512: p_pk2 => null,
513: p_pk3 => null,
514: p_pk4 => null,
515: p_pk5 => null);
516: -- INSERT A NEW ROW IN TO THE AMW_PROCESS_ORGANIZATION..
517: INSERT INTO AMW_PROCESS_ORGANIZATION(
518: PROCESS_ORGANIZATION_ID,
519: PROCESS_ID,
520: STANDARD_PROCESS_FLAG,

Line 517: INSERT INTO AMW_PROCESS_ORGANIZATION(

513: p_pk3 => null,
514: p_pk4 => null,
515: p_pk5 => null);
516: -- INSERT A NEW ROW IN TO THE AMW_PROCESS_ORGANIZATION..
517: INSERT INTO AMW_PROCESS_ORGANIZATION(
518: PROCESS_ORGANIZATION_ID,
519: PROCESS_ID,
520: STANDARD_PROCESS_FLAG,
521: APPROVAL_STATUS,

Line 537: AMW_PROCESS_ORGANIZATION_S.nextval,

533: LAST_UPDATED_BY,
534: LAST_UPDATE_DATE,
535: LAST_UPDATE_LOGIN)
536: values(
537: AMW_PROCESS_ORGANIZATION_S.nextval,
538: -2,
539: 'Y',
540: 'A',
541: org.organization_id,