APPS.AHL_PC_APPROVAL_PVT dependencies on AHL_PC_HEADERS_B

Line 33: from AHL_pc_headers_b

29:
30: cursor GET_PC_HEADER_DET(c_pc_header_id number)
31: is
32: select PC_HEADER_ID, name
33: from AHL_pc_headers_b
34: where PC_HEADER_ID = c_pc_header_id;
35:
36: l_pc_header_rec GET_PC_HEADER_DET%rowtype;
37:

Line 327: from AHL_PC_headers_b

323:
324: cursor GET_PC_HEADER_DET(c_pc_header_id number)
325: is
326: select PC_HEADER_ID,Name
327: from AHL_PC_headers_b
328: where PC_HEADER_ID=c_pc_header_id;
329:
330: l_pc_header_rec GET_PC_HEADER_DET%rowtype;
331:

Line 457: from AHL_PC_headers_b

453:
454: cursor GET_PC_HEADER_DET(c_pc_header_id number)
455: is
456: select PC_HEADER_ID,Name
457: from AHL_PC_headers_b
458: where PC_HEADER_ID=c_pc_header_id;
459:
460: l_pc_header_rec GET_PC_HEADER_DET%rowtype;
461:

Line 584: from AHL_PC_headers_b

580:
581: cursor GET_PC_HEADER_DET(c_pc_header_id number)
582: is
583: select PC_HEADER_ID,Name
584: from AHL_PC_headers_b
585: where PC_HEADER_ID=c_pc_header_id;
586:
587: l_pc_header_rec GET_PC_HEADER_DET%rowtype;
588:

Line 705: from AHL_PC_headers_b

701:
702: cursor GET_PC_HEADER_DET(c_pc_header_id number)
703: is
704: select PC_HEADER_ID,Name
705: from AHL_PC_headers_b
706: where PC_HEADER_ID=c_pc_header_id;
707:
708: l_pc_header_rec GET_PC_HEADER_DET%rowtype;
709:

Line 835: from AHL_PC_headers_b

831:
832: cursor GET_PC_HEADER_DET(c_pc_header_id number)
833: is
834: select PC_HEADER_ID,Name
835: from AHL_PC_headers_b
836: where PC_HEADER_ID=c_pc_header_id;
837:
838: l_pc_header_rec GET_PC_HEADER_DET%rowtype;
839:

Line 974: from AHL_PC_headers_b

970:
971: cursor GET_PC_HEADER_DET(c_pc_header_id number)
972: is
973: select PC_HEADER_ID,Name
974: from AHL_PC_headers_b
975: where PC_HEADER_ID=c_pc_header_id;
976:
977: l_pc_header_rec GET_PC_HEADER_DET%rowtype;
978:

Line 1109: from AHL_PC_headers_b

1105:
1106: cursor GET_PC_HEADER_DET(c_pc_header_id number)
1107: is
1108: select PC_HEADER_ID,Name
1109: from AHL_PC_headers_b
1110: where PC_HEADER_ID=c_pc_header_id;
1111:
1112: l_pc_header_rec GET_PC_HEADER_DET%rowtype;
1113:

Line 1154: UPDATE AHL_PC_HEADERS_B

1150: );
1151:
1152: /*
1153: -- Why were we doing this? INVALID is not a valid status.
1154: UPDATE AHL_PC_HEADERS_B
1155: SET STATUS='INVALID'
1156: WHERE PC_HEADER_ID=l_object_id;
1157: */
1158:

Line 1508: from AHL_PC_headers_b

1504:
1505: cursor GET_PC_HEADER_DET(c_pc_header_id number)
1506: is
1507: select PC_HEADER_ID,Name
1508: from AHL_PC_headers_b
1509: where PC_HEADER_ID=c_pc_header_id;
1510:
1511: l_pc_header_rec GET_PC_HEADER_DET%rowtype;
1512:

Line 1557: UPDATE AHL_PC_HEADERS_B

1553: END IF;
1554:
1555: l_status_date := SYSDATE;
1556:
1557: UPDATE AHL_PC_HEADERS_B
1558: SET STATUS = 'DRAFT',
1559: OBJECT_VERSION_NUMBER = l_object_version_number + 1
1560: WHERE PC_HEADER_ID = l_object_id AND
1561: OBJECT_VERSION_NUMBER = l_object_version_number;