eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QLTDACTB dependencies on QLTNINRB

Line 576: QLTNINRB.INIT_CURSOR(P_PLAN_ID, NULL, X_TXN_HEADER_ID, P_OCCURRENCE);

572: -- For Bug1843356. Added the IF condition below.
573: -- kabalakr 22 feb 02
574:
575: IF (P_OCCURRENCE IS NOT NULL) THEN
576: QLTNINRB.INIT_CURSOR(P_PLAN_ID, NULL, X_TXN_HEADER_ID, P_OCCURRENCE);
577: ELSIF nvl(X_PASSED_ID_NAME, 'TXN_HEADER_ID') = 'TXN_HEADER_ID' then
578: QLTNINRB.INIT_CURSOR(NULL, X_TXN_HEADER_ID, NULL, NULL);
579: ELSE
580: QLTNINRB.INIT_CURSOR(NULL, NULL, X_TXN_HEADER_ID, NULL) ;

Line 578: QLTNINRB.INIT_CURSOR(NULL, X_TXN_HEADER_ID, NULL, NULL);

574:
575: IF (P_OCCURRENCE IS NOT NULL) THEN
576: QLTNINRB.INIT_CURSOR(P_PLAN_ID, NULL, X_TXN_HEADER_ID, P_OCCURRENCE);
577: ELSIF nvl(X_PASSED_ID_NAME, 'TXN_HEADER_ID') = 'TXN_HEADER_ID' then
578: QLTNINRB.INIT_CURSOR(NULL, X_TXN_HEADER_ID, NULL, NULL);
579: ELSE
580: QLTNINRB.INIT_CURSOR(NULL, NULL, X_TXN_HEADER_ID, NULL) ;
581: END IF ;
582:

Line 580: QLTNINRB.INIT_CURSOR(NULL, NULL, X_TXN_HEADER_ID, NULL) ;

576: QLTNINRB.INIT_CURSOR(P_PLAN_ID, NULL, X_TXN_HEADER_ID, P_OCCURRENCE);
577: ELSIF nvl(X_PASSED_ID_NAME, 'TXN_HEADER_ID') = 'TXN_HEADER_ID' then
578: QLTNINRB.INIT_CURSOR(NULL, X_TXN_HEADER_ID, NULL, NULL);
579: ELSE
580: QLTNINRB.INIT_CURSOR(NULL, NULL, X_TXN_HEADER_ID, NULL) ;
581: END IF ;
582:
583: WHILE QLTNINRB.NEXT_ROW LOOP
584:

Line 583: WHILE QLTNINRB.NEXT_ROW LOOP

579: ELSE
580: QLTNINRB.INIT_CURSOR(NULL, NULL, X_TXN_HEADER_ID, NULL) ;
581: END IF ;
582:
583: WHILE QLTNINRB.NEXT_ROW LOOP
584:
585: -- get collection id, creation date, spec id and plan id
586: X_COLLECTION_ID := to_number(QLTNINRB.NAME_IN('COLLECTION_ID'));
587: X_CREATION_DATE := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'));

Line 586: X_COLLECTION_ID := to_number(QLTNINRB.NAME_IN('COLLECTION_ID'));

582:
583: WHILE QLTNINRB.NEXT_ROW LOOP
584:
585: -- get collection id, creation date, spec id and plan id
586: X_COLLECTION_ID := to_number(QLTNINRB.NAME_IN('COLLECTION_ID'));
587: X_CREATION_DATE := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'));
588: Y_SPEC_ID := to_number(QLTNINRB.NAME_IN('SPEC_ID'));
589: Y_PLAN_ID := to_number(QLTNINRB.NAME_IN('PLAN_ID'));
590:

Line 587: X_CREATION_DATE := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'));

583: WHILE QLTNINRB.NEXT_ROW LOOP
584:
585: -- get collection id, creation date, spec id and plan id
586: X_COLLECTION_ID := to_number(QLTNINRB.NAME_IN('COLLECTION_ID'));
587: X_CREATION_DATE := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'));
588: Y_SPEC_ID := to_number(QLTNINRB.NAME_IN('SPEC_ID'));
589: Y_PLAN_ID := to_number(QLTNINRB.NAME_IN('PLAN_ID'));
590:
591: -- Bug 5111269.

Line 588: Y_SPEC_ID := to_number(QLTNINRB.NAME_IN('SPEC_ID'));

584:
585: -- get collection id, creation date, spec id and plan id
586: X_COLLECTION_ID := to_number(QLTNINRB.NAME_IN('COLLECTION_ID'));
587: X_CREATION_DATE := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'));
588: Y_SPEC_ID := to_number(QLTNINRB.NAME_IN('SPEC_ID'));
589: Y_PLAN_ID := to_number(QLTNINRB.NAME_IN('PLAN_ID'));
590:
591: -- Bug 5111269.
592: -- In EAM Transactions we are not supporting Specifications at plan level.

Line 589: Y_PLAN_ID := to_number(QLTNINRB.NAME_IN('PLAN_ID'));

585: -- get collection id, creation date, spec id and plan id
586: X_COLLECTION_ID := to_number(QLTNINRB.NAME_IN('COLLECTION_ID'));
587: X_CREATION_DATE := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'));
588: Y_SPEC_ID := to_number(QLTNINRB.NAME_IN('SPEC_ID'));
589: Y_PLAN_ID := to_number(QLTNINRB.NAME_IN('PLAN_ID'));
590:
591: -- Bug 5111269.
592: -- In EAM Transactions we are not supporting Specifications at plan level.
593: -- We support specifications at element level only. Since specifications is

Line 640: X_OCCURRENCE := TO_NUMBER(QLTNINRB.NAME_IN('OCCURRENCE'));

636: if NVL(X_ARGUMENT,NULL) = 'IMPORT' THEN
637: BEGIN
638:
639: I := 0;
640: X_OCCURRENCE := TO_NUMBER(QLTNINRB.NAME_IN('OCCURRENCE'));
641: FOR UPDATED_RES_COLUMNS IN
642: (SELECT CHAR_ID
643: FROM QA_RESULTS_UPDATE_HISTORY
644: WHERE TXN_HEADER_ID = X_TXN_HEADER_ID

Line 745: QLTNINRB.NAME_IN(column_tab(i)));

741: -- comparison can be evaluated. Checking FK_LOOKUP_TYPE locally
742: -- saves us an unnecessary database hit.
743: IF fk_type_tab(i) in (0, 1, 3)
744: THEN result := QLTSMENB.LOOKUP(char_id_tab(i),
745: QLTNINRB.NAME_IN(column_tab(i)));
746: ELSE result := QLTNINRB.NAME_IN(column_tab(i));
747: END IF;
748: done := FALSE;
749:

Line 746: ELSE result := QLTNINRB.NAME_IN(column_tab(i));

742: -- saves us an unnecessary database hit.
743: IF fk_type_tab(i) in (0, 1, 3)
744: THEN result := QLTSMENB.LOOKUP(char_id_tab(i),
745: QLTNINRB.NAME_IN(column_tab(i)));
746: ELSE result := QLTNINRB.NAME_IN(column_tab(i));
747: END IF;
748: done := FALSE;
749:
750: -- Added for update capabilities...

Line 827: output := to_number(QLTNINRB.NAME_IN('WIP_ENTITY_ID'));

823: operator_tab(i),low_value_tab(i),
824: high_value_tab(i),X_message,
825: result,X_CONCURRENT);
826: END IF;
827: output := to_number(QLTNINRB.NAME_IN('WIP_ENTITY_ID'));
828: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
829:
830: -- call WIP api
831: BEGIN

Line 828: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));

824: high_value_tab(i),X_message,
825: result,X_CONCURRENT);
826: END IF;
827: output := to_number(QLTNINRB.NAME_IN('WIP_ENTITY_ID'));
828: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
829:
830: -- call WIP api
831: BEGIN
832: WIP_CHANGE_STATUS.PUT_JOB_ON_HOLD(output, X_org_id);

Line 865: output := to_number(QLTNINRB.NAME_IN('WIP_ENTITY_ID'));

861: OPEN MY_STEP(Y_PLAN_ID);
862: FETCH MY_STEP INTO RES_COL_NAME;
863: CLOSE MY_STEP;
864:
865: output := to_number(QLTNINRB.NAME_IN('WIP_ENTITY_ID'));
866: output2 := to_number(QLTNINRB.NAME_IN('LINE_ID'));
867: output3 := to_number(QLTNINRB.NAME_IN('TO_OP_SEQ_NUM'));
868: INTEROP_STEP := QLTNINRB.NAME_IN(RES_COL_NAME);
869:

Line 866: output2 := to_number(QLTNINRB.NAME_IN('LINE_ID'));

862: FETCH MY_STEP INTO RES_COL_NAME;
863: CLOSE MY_STEP;
864:
865: output := to_number(QLTNINRB.NAME_IN('WIP_ENTITY_ID'));
866: output2 := to_number(QLTNINRB.NAME_IN('LINE_ID'));
867: output3 := to_number(QLTNINRB.NAME_IN('TO_OP_SEQ_NUM'));
868: INTEROP_STEP := QLTNINRB.NAME_IN(RES_COL_NAME);
869:
870: OPEN MY_STEP_LOOKUP(INTEROP_STEP);

Line 867: output3 := to_number(QLTNINRB.NAME_IN('TO_OP_SEQ_NUM'));

863: CLOSE MY_STEP;
864:
865: output := to_number(QLTNINRB.NAME_IN('WIP_ENTITY_ID'));
866: output2 := to_number(QLTNINRB.NAME_IN('LINE_ID'));
867: output3 := to_number(QLTNINRB.NAME_IN('TO_OP_SEQ_NUM'));
868: INTEROP_STEP := QLTNINRB.NAME_IN(RES_COL_NAME);
869:
870: OPEN MY_STEP_LOOKUP(INTEROP_STEP);
871: FETCH MY_STEP_LOOKUP INTO output4;

Line 868: INTEROP_STEP := QLTNINRB.NAME_IN(RES_COL_NAME);

864:
865: output := to_number(QLTNINRB.NAME_IN('WIP_ENTITY_ID'));
866: output2 := to_number(QLTNINRB.NAME_IN('LINE_ID'));
867: output3 := to_number(QLTNINRB.NAME_IN('TO_OP_SEQ_NUM'));
868: INTEROP_STEP := QLTNINRB.NAME_IN(RES_COL_NAME);
869:
870: OPEN MY_STEP_LOOKUP(INTEROP_STEP);
871: FETCH MY_STEP_LOOKUP INTO output4;
872: CLOSE MY_STEP_LOOKUP;

Line 874: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));

870: OPEN MY_STEP_LOOKUP(INTEROP_STEP);
871: FETCH MY_STEP_LOOKUP INTO output4;
872: CLOSE MY_STEP_LOOKUP;
873:
874: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
875:
876: -- call WIP api
877: BEGIN
878: WIP_SF_STATUS.ATTACH(output,X_org_id,output2,

Line 907: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));

903: FETCH MY_STATUS_ID INTO X_STATUS_ID;
904: CLOSE MY_STATUS_ID;
905:
906: -- get the org id, lot number and item id
907: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
908: X_lot_number := QLTNINRB.NAME_IN('LOT_NUMBER');
909: X_Item_id := to_number (QLTNINRB.Name_in('ITEM_ID' )) ;
910:
911: -- call Inventory API

Line 908: X_lot_number := QLTNINRB.NAME_IN('LOT_NUMBER');

904: CLOSE MY_STATUS_ID;
905:
906: -- get the org id, lot number and item id
907: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
908: X_lot_number := QLTNINRB.NAME_IN('LOT_NUMBER');
909: X_Item_id := to_number (QLTNINRB.Name_in('ITEM_ID' )) ;
910:
911: -- call Inventory API
912: BEGIN

Line 909: X_Item_id := to_number (QLTNINRB.Name_in('ITEM_ID' )) ;

905:
906: -- get the org id, lot number and item id
907: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
908: X_lot_number := QLTNINRB.NAME_IN('LOT_NUMBER');
909: X_Item_id := to_number (QLTNINRB.Name_in('ITEM_ID' )) ;
910:
911: -- call Inventory API
912: BEGIN
913: INV_MATERIAL_STATUS_GRP.UPDATE_STATUS(

Line 967: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));

963: FETCH MY_STATUS_ID INTO X_STATUS_ID;
964: CLOSE MY_STATUS_ID;
965:
966: -- get the org id, serial number and item id
967: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
968: X_serial_number := QLTNINRB.NAME_IN('SERIAL_NUMBER');
969: X_Item_id := to_number (QLTNINRB.Name_in('ITEM_ID' )) ;
970:
971: -- call Inventory API

Line 968: X_serial_number := QLTNINRB.NAME_IN('SERIAL_NUMBER');

964: CLOSE MY_STATUS_ID;
965:
966: -- get the org id, serial number and item id
967: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
968: X_serial_number := QLTNINRB.NAME_IN('SERIAL_NUMBER');
969: X_Item_id := to_number (QLTNINRB.Name_in('ITEM_ID' )) ;
970:
971: -- call Inventory API
972: BEGIN

Line 969: X_Item_id := to_number (QLTNINRB.Name_in('ITEM_ID' )) ;

965:
966: -- get the org id, serial number and item id
967: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
968: X_serial_number := QLTNINRB.NAME_IN('SERIAL_NUMBER');
969: X_Item_id := to_number (QLTNINRB.Name_in('ITEM_ID' )) ;
970:
971: -- call Inventory API
972: BEGIN
973: INV_MATERIAL_STATUS_GRP.UPDATE_STATUS(

Line 1025: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));

1021: X_CREATION_DATE,0,
1022: 0,'',
1023: '',X_message,
1024: '',X_CONCURRENT);
1025: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1026: X_Vendor_id := to_number(QLTNINRB.NAME_IN('VENDOR_ID'));
1027:
1028: -- get the operating unit
1029: OPEN MY_OP_UNIT(X_ORG_ID);

Line 1026: X_Vendor_id := to_number(QLTNINRB.NAME_IN('VENDOR_ID'));

1022: 0,'',
1023: '',X_message,
1024: '',X_CONCURRENT);
1025: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1026: X_Vendor_id := to_number(QLTNINRB.NAME_IN('VENDOR_ID'));
1027:
1028: -- get the operating unit
1029: OPEN MY_OP_UNIT(X_ORG_ID);
1030: FETCH MY_OP_UNIT INTO X_OP_UNIT;

Line 1063: to_number(QLTNINRB.NAME_IN('PO_HEADER_ID')),

1059: '',X_message,
1060: '',X_CONCURRENT);
1061: BEGIN
1062: retnum := PO_DOCUMENT_ACTIONS_SV.PO_HOLD_DOCUMENT(
1063: to_number(QLTNINRB.NAME_IN('PO_HEADER_ID')),
1064: to_number(QLTNINRB.NAME_IN('PO_RELEASE_ID')),
1065: x_msg_data);
1066: IF retnum <> 0 THEN
1067: RAISE po_api_failed;

Line 1064: to_number(QLTNINRB.NAME_IN('PO_RELEASE_ID')),

1060: '',X_CONCURRENT);
1061: BEGIN
1062: retnum := PO_DOCUMENT_ACTIONS_SV.PO_HOLD_DOCUMENT(
1063: to_number(QLTNINRB.NAME_IN('PO_HEADER_ID')),
1064: to_number(QLTNINRB.NAME_IN('PO_RELEASE_ID')),
1065: x_msg_data);
1066: IF retnum <> 0 THEN
1067: RAISE po_api_failed;
1068: END IF;

Line 1090: output := to_number(QLTNINRB.NAME_IN('WIP_ENTITY_ID'));

1086: X_CREATION_DATE,0,
1087: 0,'',
1088: '',X_message,
1089: '',X_CONCURRENT);
1090: output := to_number(QLTNINRB.NAME_IN('WIP_ENTITY_ID'));
1091: output2 := to_number(QLTNINRB.NAME_IN('LINE_ID'));
1092: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1093:
1094: -- AG: QWB: wip_entity_id is needed to put the schedule on hold.

Line 1091: output2 := to_number(QLTNINRB.NAME_IN('LINE_ID'));

1087: 0,'',
1088: '',X_message,
1089: '',X_CONCURRENT);
1090: output := to_number(QLTNINRB.NAME_IN('WIP_ENTITY_ID'));
1091: output2 := to_number(QLTNINRB.NAME_IN('LINE_ID'));
1092: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1093:
1094: -- AG: QWB: wip_entity_id is needed to put the schedule on hold.
1095: IF output IS NULL THEN

Line 1092: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));

1088: '',X_message,
1089: '',X_CONCURRENT);
1090: output := to_number(QLTNINRB.NAME_IN('WIP_ENTITY_ID'));
1091: output2 := to_number(QLTNINRB.NAME_IN('LINE_ID'));
1092: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1093:
1094: -- AG: QWB: wip_entity_id is needed to put the schedule on hold.
1095: IF output IS NULL THEN
1096: BEGIN

Line 1104: AND we.primary_item_id = to_number(QLTNINRB.NAME_IN('ITEM_ID'));

1100: WHERE wrs.organization_id = x_org_id
1101: AND wrs.line_id = output2
1102: AND we.wip_entity_id = wrs.wip_entity_id
1103: AND we.organization_id = wrs.organization_id
1104: AND we.primary_item_id = to_number(QLTNINRB.NAME_IN('ITEM_ID'));
1105: EXCEPTION
1106: WHEN OTHERS THEN
1107: NULL;
1108: END;

Line 1141: X_OCCURRENCE := to_number(QLTNINRB.NAME_IN('OCCURRENCE'));

1137: X_CREATION_DATE,0,
1138: 0,'',
1139: '',X_message,
1140: '',X_CONCURRENT);
1141: X_OCCURRENCE := to_number(QLTNINRB.NAME_IN('OCCURRENCE'));
1142:
1143: OPEN MY_ASSIGNED_CHAR_ID(pca_id_tab(i), action_id_tab(i));
1144: FETCH MY_ASSIGNED_CHAR_ID INTO X_ASSIGNED_CHAR_ID;
1145: CLOSE MY_ASSIGNED_CHAR_ID;

Line 1186: to_number(QLTNINRB.NAME_IN('TRANSACTION_NUMBER'));

1182: ELSIF action_id_tab(i) in (25, 26) AND
1183: x_action_type = 'IMMEDIATE' THEN
1184: x_progress := 2;
1185: X_TRANSACTION_NUMBER :=
1186: to_number(QLTNINRB.NAME_IN('TRANSACTION_NUMBER'));
1187:
1188: -- only allow action if from inspection transaction
1189:
1190: --

Line 1222: X_TRANSACTION_ID := QLTNINRB.NAME_IN('TRANSACTION_ID');

1218: '',X_message,
1219: '',X_CONCURRENT);
1220: END IF;
1221:
1222: X_TRANSACTION_ID := QLTNINRB.NAME_IN('TRANSACTION_ID');
1223:
1224: x_progress := 3;
1225: IF X_TRANSACTION_ID IS NULL THEN
1226: x_progress := 4;

Line 1231: X_LAST_UPDATED_BY := QLTNINRB.NAME_IN('LAST_UPDATED_BY');

1227: RAISE null_txn_id;
1228: END IF;
1229:
1230: x_progress := 5;
1231: X_LAST_UPDATED_BY := QLTNINRB.NAME_IN('LAST_UPDATED_BY');
1232: X_LOGIN := QLTNINRB.NAME_IN('LAST_UPDATE_LOGIN');
1233: OPEN MY_RESULTS_COLUMN(Y_PLAN_ID);
1234:
1235: -- loop through collection elements, extracting

Line 1232: X_LOGIN := QLTNINRB.NAME_IN('LAST_UPDATE_LOGIN');

1228: END IF;
1229:
1230: x_progress := 5;
1231: X_LAST_UPDATED_BY := QLTNINRB.NAME_IN('LAST_UPDATED_BY');
1232: X_LOGIN := QLTNINRB.NAME_IN('LAST_UPDATE_LOGIN');
1233: OPEN MY_RESULTS_COLUMN(Y_PLAN_ID);
1234:
1235: -- loop through collection elements, extracting
1236: -- the ones required for the action

Line 1241: result_value := QLTNINRB.NAME_IN(RC.Q_COLUMN);

1237: LOOP
1238: FETCH MY_RESULTS_COLUMN INTO RC;
1239: EXIT WHEN MY_RESULTS_COLUMN%NOTFOUND;
1240:
1241: result_value := QLTNINRB.NAME_IN(RC.Q_COLUMN);
1242: IF RC.DEV_NAME = 'TRANSACTION_DATE' THEN
1243: X_TRANSACTION_DATE := qltdate.any_to_date(result_value);
1244: ELSIF RC.DEV_NAME = 'QUANTITY' THEN
1245: X_QUANTITY := result_value;

Line 1301: X_ORG_ID := TO_NUMBER(QLTNINRB.NAME_IN('ORGANIZATION_ID'));

1297:
1298: -- Fetching the value of org_id. For RCV/WMS project.
1299: -- Bug 3096256. kabalakr Mon Aug 18 03:18:19 PDT 2003.
1300:
1301: X_ORG_ID := TO_NUMBER(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1302:
1303:
1304: IF X_TRANSACTION_DATE IS NULL OR
1305: X_QUANTITY IS NULL OR

Line 1704: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));

1700:
1701:
1702: --Create work request added by kaza
1703: ELSIF action_id_tab(i) = 29 and nvl(x_action_type, 'DEFERRED') = 'DEFERRED' THEN
1704: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1705: X_OCCURRENCE := to_number(QLTNINRB.NAME_IN('OCCURRENCE'));
1706: --dgupta: Start R12 EAM Integration. Bug 4345492
1707: X_ASSET_INSTANCE_ID := QLTNINRB.NAME_IN('ASSET_INSTANCE_ID');
1708: if (X_ASSET_INSTANCE_ID is null) then

Line 1705: X_OCCURRENCE := to_number(QLTNINRB.NAME_IN('OCCURRENCE'));

1701:
1702: --Create work request added by kaza
1703: ELSIF action_id_tab(i) = 29 and nvl(x_action_type, 'DEFERRED') = 'DEFERRED' THEN
1704: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1705: X_OCCURRENCE := to_number(QLTNINRB.NAME_IN('OCCURRENCE'));
1706: --dgupta: Start R12 EAM Integration. Bug 4345492
1707: X_ASSET_INSTANCE_ID := QLTNINRB.NAME_IN('ASSET_INSTANCE_ID');
1708: if (X_ASSET_INSTANCE_ID is null) then
1709: X_ASSET_GROUP_ID := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));

Line 1707: X_ASSET_INSTANCE_ID := QLTNINRB.NAME_IN('ASSET_INSTANCE_ID');

1703: ELSIF action_id_tab(i) = 29 and nvl(x_action_type, 'DEFERRED') = 'DEFERRED' THEN
1704: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1705: X_OCCURRENCE := to_number(QLTNINRB.NAME_IN('OCCURRENCE'));
1706: --dgupta: Start R12 EAM Integration. Bug 4345492
1707: X_ASSET_INSTANCE_ID := QLTNINRB.NAME_IN('ASSET_INSTANCE_ID');
1708: if (X_ASSET_INSTANCE_ID is null) then
1709: X_ASSET_GROUP_ID := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));
1710: X_ASSET_NUMBER := QLTNINRB.NAME_IN('ASSET_NUMBER');
1711: end if;

Line 1709: X_ASSET_GROUP_ID := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));

1705: X_OCCURRENCE := to_number(QLTNINRB.NAME_IN('OCCURRENCE'));
1706: --dgupta: Start R12 EAM Integration. Bug 4345492
1707: X_ASSET_INSTANCE_ID := QLTNINRB.NAME_IN('ASSET_INSTANCE_ID');
1708: if (X_ASSET_INSTANCE_ID is null) then
1709: X_ASSET_GROUP_ID := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));
1710: X_ASSET_NUMBER := QLTNINRB.NAME_IN('ASSET_NUMBER');
1711: end if;
1712: --dgupta: End R12 EAM Integration. Bug 4345492
1713:

Line 1710: X_ASSET_NUMBER := QLTNINRB.NAME_IN('ASSET_NUMBER');

1706: --dgupta: Start R12 EAM Integration. Bug 4345492
1707: X_ASSET_INSTANCE_ID := QLTNINRB.NAME_IN('ASSET_INSTANCE_ID');
1708: if (X_ASSET_INSTANCE_ID is null) then
1709: X_ASSET_GROUP_ID := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));
1710: X_ASSET_NUMBER := QLTNINRB.NAME_IN('ASSET_NUMBER');
1711: end if;
1712: --dgupta: End R12 EAM Integration. Bug 4345492
1713:
1714: -- check to see if priority element exists in the plan

Line 1725: Priority_value := QLTNINRB.NAME_IN(Priority_soft_column);

1721: OPEN Get_result_column_name (ELEMENT_ID, Y_PLAN_ID);
1722: FETCH Get_result_column_name INTO Priority_soft_column;
1723: CLOSE Get_result_column_name;
1724:
1725: Priority_value := QLTNINRB.NAME_IN(Priority_soft_column);
1726:
1727: if (Priority_value is not null) then
1728: OPEN Get_priority_id (Priority_value);
1729: FETCH Get_priority_id INTO Priority_id;

Line 1826: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));

1822:
1823:
1824: ELSIF action_id_tab(i) = 30 and nvl(x_action_type, 'DEFERRED') = 'DEFERRED' THEN
1825:
1826: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1827: --dgupta: Start R12 EAM Integration. Bug 4345492
1828: X_ASSET_INSTANCE_ID := QLTNINRB.NAME_IN('ASSET_INSTANCE_ID');
1829:
1830: if (X_ASSET_INSTANCE_ID is not null) then

Line 1828: X_ASSET_INSTANCE_ID := QLTNINRB.NAME_IN('ASSET_INSTANCE_ID');

1824: ELSIF action_id_tab(i) = 30 and nvl(x_action_type, 'DEFERRED') = 'DEFERRED' THEN
1825:
1826: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1827: --dgupta: Start R12 EAM Integration. Bug 4345492
1828: X_ASSET_INSTANCE_ID := QLTNINRB.NAME_IN('ASSET_INSTANCE_ID');
1829:
1830: if (X_ASSET_INSTANCE_ID is not null) then
1831: l_work_order_rec.maintenance_object_id := X_ASSET_INSTANCE_ID;
1832: l_work_order_rec.maintenance_object_type := 3;

Line 1833: l_work_order_rec.asset_group_id := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));

1829:
1830: if (X_ASSET_INSTANCE_ID is not null) then
1831: l_work_order_rec.maintenance_object_id := X_ASSET_INSTANCE_ID;
1832: l_work_order_rec.maintenance_object_type := 3;
1833: l_work_order_rec.asset_group_id := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));
1834: l_work_order_rec.asset_number := QLTNINRB.NAME_IN('ASSET_NUMBER');
1835: else
1836: X_ASSET_GROUP_ID := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));
1837: X_ASSET_NUMBER := QLTNINRB.NAME_IN('ASSET_NUMBER');

Line 1834: l_work_order_rec.asset_number := QLTNINRB.NAME_IN('ASSET_NUMBER');

1830: if (X_ASSET_INSTANCE_ID is not null) then
1831: l_work_order_rec.maintenance_object_id := X_ASSET_INSTANCE_ID;
1832: l_work_order_rec.maintenance_object_type := 3;
1833: l_work_order_rec.asset_group_id := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));
1834: l_work_order_rec.asset_number := QLTNINRB.NAME_IN('ASSET_NUMBER');
1835: else
1836: X_ASSET_GROUP_ID := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));
1837: X_ASSET_NUMBER := QLTNINRB.NAME_IN('ASSET_NUMBER');
1838: if (X_ASSET_GROUP_ID is not null and X_ASSET_NUMBER is null) then

Line 1836: X_ASSET_GROUP_ID := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));

1832: l_work_order_rec.maintenance_object_type := 3;
1833: l_work_order_rec.asset_group_id := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));
1834: l_work_order_rec.asset_number := QLTNINRB.NAME_IN('ASSET_NUMBER');
1835: else
1836: X_ASSET_GROUP_ID := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));
1837: X_ASSET_NUMBER := QLTNINRB.NAME_IN('ASSET_NUMBER');
1838: if (X_ASSET_GROUP_ID is not null and X_ASSET_NUMBER is null) then
1839: l_work_order_rec.maintenance_object_id := X_ASSET_GROUP_ID;
1840: l_work_order_rec.rebuild_item_id :=X_ASSET_GROUP_ID;

Line 1837: X_ASSET_NUMBER := QLTNINRB.NAME_IN('ASSET_NUMBER');

1833: l_work_order_rec.asset_group_id := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));
1834: l_work_order_rec.asset_number := QLTNINRB.NAME_IN('ASSET_NUMBER');
1835: else
1836: X_ASSET_GROUP_ID := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));
1837: X_ASSET_NUMBER := QLTNINRB.NAME_IN('ASSET_NUMBER');
1838: if (X_ASSET_GROUP_ID is not null and X_ASSET_NUMBER is null) then
1839: l_work_order_rec.maintenance_object_id := X_ASSET_GROUP_ID;
1840: l_work_order_rec.rebuild_item_id :=X_ASSET_GROUP_ID;
1841: l_work_order_rec.maintenance_object_type := 2;

Line 1846: l_work_order_rec.asset_group_id := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));

1842: elsif (X_ASSET_GROUP_ID is not null) then
1843: l_work_order_rec.maintenance_object_id :=
1844: qa_plan_element_api.get_asset_instance_id(X_ASSET_GROUP_ID, X_ASSET_NUMBER);
1845: l_work_order_rec.maintenance_object_type := 3;
1846: l_work_order_rec.asset_group_id := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));
1847: l_work_order_rec.asset_number := QLTNINRB.NAME_IN('ASSET_NUMBER');
1848:
1849: end if;
1850: end if;

Line 1847: l_work_order_rec.asset_number := QLTNINRB.NAME_IN('ASSET_NUMBER');

1843: l_work_order_rec.maintenance_object_id :=
1844: qa_plan_element_api.get_asset_instance_id(X_ASSET_GROUP_ID, X_ASSET_NUMBER);
1845: l_work_order_rec.maintenance_object_type := 3;
1846: l_work_order_rec.asset_group_id := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));
1847: l_work_order_rec.asset_number := QLTNINRB.NAME_IN('ASSET_NUMBER');
1848:
1849: end if;
1850: end if;
1851:

Line 1852: l_followup_activity_id := QLTNINRB.NAME_IN('FOLLOWUP_ACTIVITY_ID');

1848:
1849: end if;
1850: end if;
1851:
1852: l_followup_activity_id := QLTNINRB.NAME_IN('FOLLOWUP_ACTIVITY_ID');
1853: --dgupta: End R12 EAM Integration. Bug 4345492
1854: l_work_order_rec.primary_item_id := l_followup_activity_id;
1855:
1856: l_work_order_rec.last_update_date := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'));

Line 1856: l_work_order_rec.last_update_date := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'));

1852: l_followup_activity_id := QLTNINRB.NAME_IN('FOLLOWUP_ACTIVITY_ID');
1853: --dgupta: End R12 EAM Integration. Bug 4345492
1854: l_work_order_rec.primary_item_id := l_followup_activity_id;
1855:
1856: l_work_order_rec.last_update_date := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'));
1857: l_work_order_rec.last_updated_by := QLTNINRB.NAME_IN('LAST_UPDATED_BY');
1858: l_work_order_rec.creation_date := x_creation_date;
1859: l_work_order_rec.created_by := QLTNINRB.NAME_IN('CREATED_BY');
1860: l_work_order_rec.last_update_login := QLTNINRB.NAME_IN('LAST_UPDATE_LOGIN');

Line 1857: l_work_order_rec.last_updated_by := QLTNINRB.NAME_IN('LAST_UPDATED_BY');

1853: --dgupta: End R12 EAM Integration. Bug 4345492
1854: l_work_order_rec.primary_item_id := l_followup_activity_id;
1855:
1856: l_work_order_rec.last_update_date := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'));
1857: l_work_order_rec.last_updated_by := QLTNINRB.NAME_IN('LAST_UPDATED_BY');
1858: l_work_order_rec.creation_date := x_creation_date;
1859: l_work_order_rec.created_by := QLTNINRB.NAME_IN('CREATED_BY');
1860: l_work_order_rec.last_update_login := QLTNINRB.NAME_IN('LAST_UPDATE_LOGIN');
1861:

Line 1859: l_work_order_rec.created_by := QLTNINRB.NAME_IN('CREATED_BY');

1855:
1856: l_work_order_rec.last_update_date := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'));
1857: l_work_order_rec.last_updated_by := QLTNINRB.NAME_IN('LAST_UPDATED_BY');
1858: l_work_order_rec.creation_date := x_creation_date;
1859: l_work_order_rec.created_by := QLTNINRB.NAME_IN('CREATED_BY');
1860: l_work_order_rec.last_update_login := QLTNINRB.NAME_IN('LAST_UPDATE_LOGIN');
1861:
1862: l_work_order_rec.organization_id := X_org_id;
1863: l_work_order_rec.load_type := 7;

Line 1860: l_work_order_rec.last_update_login := QLTNINRB.NAME_IN('LAST_UPDATE_LOGIN');

1856: l_work_order_rec.last_update_date := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'));
1857: l_work_order_rec.last_updated_by := QLTNINRB.NAME_IN('LAST_UPDATED_BY');
1858: l_work_order_rec.creation_date := x_creation_date;
1859: l_work_order_rec.created_by := QLTNINRB.NAME_IN('CREATED_BY');
1860: l_work_order_rec.last_update_login := QLTNINRB.NAME_IN('LAST_UPDATE_LOGIN');
1861:
1862: l_work_order_rec.organization_id := X_org_id;
1863: l_work_order_rec.load_type := 7;
1864: l_work_order_rec.wip_supply_type := 7;

Line 1929: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));

1925: OPEN MY_STATUS(pca_id_tab(i));
1926: FETCH MY_STATUS INTO X_STATUS;
1927: CLOSE MY_STATUS ;
1928: -- get the vendor , item and org id
1929: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1930: X_Vendor_id := to_number(QLTNINRB.NAME_IN('VENDOR_ID'));
1931: X_Item_id := to_number (QLTNINRB.Name_in('ITEM_ID' )) ;
1932:
1933: -- call PO API

Line 1930: X_Vendor_id := to_number(QLTNINRB.NAME_IN('VENDOR_ID'));

1926: FETCH MY_STATUS INTO X_STATUS;
1927: CLOSE MY_STATUS ;
1928: -- get the vendor , item and org id
1929: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1930: X_Vendor_id := to_number(QLTNINRB.NAME_IN('VENDOR_ID'));
1931: X_Item_id := to_number (QLTNINRB.Name_in('ITEM_ID' )) ;
1932:
1933: -- call PO API
1934: BEGIN

Line 1931: X_Item_id := to_number (QLTNINRB.Name_in('ITEM_ID' )) ;

1927: CLOSE MY_STATUS ;
1928: -- get the vendor , item and org id
1929: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1930: X_Vendor_id := to_number(QLTNINRB.NAME_IN('VENDOR_ID'));
1931: X_Item_id := to_number (QLTNINRB.Name_in('ITEM_ID' )) ;
1932:
1933: -- call PO API
1934: BEGIN
1935: PO_ASL_SV.Update_Vendor_Status (x_org_id, x_vendor_id,

Line 1992: QLTNINRB.CLOSE_CURSOR;

1988: OLD_PLAN_ID := Y_PLAN_ID;
1989:
1990: END LOOP; -- i <= total_rows
1991:
1992: QLTNINRB.CLOSE_CURSOR;
1993: RETURN(X_ERROR);
1994:
1995: EXCEPTION
1996:

Line 1999: QLTNINRB.CLOSE_CURSOR;

1995: EXCEPTION
1996:
1997: When Others THEN
1998: --dbms_output.put_line('x progress is '||to_char(x_progress));
1999: QLTNINRB.CLOSE_CURSOR;
2000: raise;
2001: END DO_ACTIONS;
2002:
2003:

Line 2145: token_value := QLTNINRB.NAME_IN(prec.Q_COLUMN);

2141: */
2142:
2143: token_datatype := prec.datatype;
2144:
2145: token_value := QLTNINRB.NAME_IN(prec.Q_COLUMN);
2146:
2147: -- Convert all normalized element ID's into its values.
2148: -- ex. Item_id,locator_id converted to item_name, locator respectively
2149: -- For performance reason, dont call qltsmenb for char_id 2,39

Line 2297: l_occurrence := TO_NUMBER(QLTNINRB.NAME_IN('OCCURRENCE'));

2293: FETCH ACTION_SET_NAME INTO X_ACTION_SET_NAME;
2294: close ACTION_SET_NAME;
2295:
2296: -- suramasw.Bug 2921276.Wed Jul 30 05:15:40 PDT 2003
2297: l_occurrence := TO_NUMBER(QLTNINRB.NAME_IN('OCCURRENCE'));
2298:
2299: -- Next we get any outputs to the alert
2300: FOR prec in OUTPUTS LOOP
2301: i := i + 1;

Line 2302: ACTUAL_OUTPUT := QLTNINRB.NAME_IN(prec.Q_COLUMN);

2298:
2299: -- Next we get any outputs to the alert
2300: FOR prec in OUTPUTS LOOP
2301: i := i + 1;
2302: ACTUAL_OUTPUT := QLTNINRB.NAME_IN(prec.Q_COLUMN);
2303: IF (prec.LOOKUP_TYPE = 0) or (prec.LOOKUP_TYPE = 1) or
2304: (prec.LOOKUP_TYPE = 3) THEN
2305: ACTUAL_OUTPUT := QLTSMENB.LOOKUP(prec.CHAR_ID, ACTUAL_OUTPUT);
2306: end IF;

Line 2478: denorm_val := to_char(QA_FLEX_UTIL.get_item_id(to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID')),denorm_val));

2474: -- ntungare
2475: --
2476: -- IF assigned_col = 'ITEM_ID' THEN
2477: IF assigned_col IN ( 'ITEM_ID', 'COMP_ITEM_ID') THEN
2478: denorm_val := to_char(QA_FLEX_UTIL.get_item_id(to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID')),denorm_val));
2479: ELSIF assigned_col = 'VENDOR_ID' THEN
2480: denorm_val := qa_plan_element_api.get_supplier_id(denorm_val);
2481: END IF;
2482: END;

Line 2622: token_column_value := QLTNINRB.NAME_IN(prec.Q_COLUMN);

2618: FOR prec in OUTPUTS LOOP
2619: EXIT WHEN find_token;
2620: IF UPPER(token_name) = UPPER(prec.token_name) THEN
2621: token_char_id := prec.char_id;
2622: token_column_value := QLTNINRB.NAME_IN(prec.Q_COLUMN);
2623: IF (prec.LOOKUP_TYPE = 0) or (prec.LOOKUP_TYPE = 1) or
2624: (prec.LOOKUP_TYPE = 3) THEN
2625: token_column_value := QLTSMENB.LOOKUP(prec.CHAR_ID,
2626: token_column_value);

Line 2840: qltninrb.set_value(y_column,return_value_char);

2836: -- Added this if-else ladder to update the record in session
2837: -- in order to fire the cascaded actions.
2838: -- skolluku
2839: IF y_datatype IN (1,4) AND (return_value_char IS NOT NULL) THEN
2840: qltninrb.set_value(y_column,return_value_char);
2841: END IF;
2842: IF y_datatype=2 and return_value_num is not null then
2843: qltninrb.set_value(y_column,to_char(return_value_num));
2844: END IF;

Line 2843: qltninrb.set_value(y_column,to_char(return_value_num));

2839: IF y_datatype IN (1,4) AND (return_value_char IS NOT NULL) THEN
2840: qltninrb.set_value(y_column,return_value_char);
2841: END IF;
2842: IF y_datatype=2 and return_value_num is not null then
2843: qltninrb.set_value(y_column,to_char(return_value_num));
2844: END IF;
2845: IF y_datatype = 6 and return_value_date is not null then
2846: IF y_column LIKE 'CHARACTER%' THEN
2847: qltninrb.set_value(y_column,qltdate.date_to_canon_dt(return_value_date));

Line 2847: qltninrb.set_value(y_column,qltdate.date_to_canon_dt(return_value_date));

2843: qltninrb.set_value(y_column,to_char(return_value_num));
2844: END IF;
2845: IF y_datatype = 6 and return_value_date is not null then
2846: IF y_column LIKE 'CHARACTER%' THEN
2847: qltninrb.set_value(y_column,qltdate.date_to_canon_dt(return_value_date));
2848: ELSE
2849: qltninrb.set_value(y_column,to_char(return_value_date));
2850: END IF;
2851: END IF;

Line 2849: qltninrb.set_value(y_column,to_char(return_value_date));

2845: IF y_datatype = 6 and return_value_date is not null then
2846: IF y_column LIKE 'CHARACTER%' THEN
2847: qltninrb.set_value(y_column,qltdate.date_to_canon_dt(return_value_date));
2848: ELSE
2849: qltninrb.set_value(y_column,to_char(return_value_date));
2850: END IF;
2851: END IF;
2852: IF y_datatype = 3 AND return_value_date IS NOT NULL THEN
2853: IF y_column LIKE 'CHARACTER%' THEN

Line 2854: qltninrb.set_value(y_column,qltdate.date_to_canon(return_value_date));

2850: END IF;
2851: END IF;
2852: IF y_datatype = 3 AND return_value_date IS NOT NULL THEN
2853: IF y_column LIKE 'CHARACTER%' THEN
2854: qltninrb.set_value(y_column,qltdate.date_to_canon(return_value_date));
2855: ELSE
2856: qltninrb.set_value(y_column,to_char(return_value_date));
2857: END IF;
2858: END IF;

Line 2856: qltninrb.set_value(y_column,to_char(return_value_date));

2852: IF y_datatype = 3 AND return_value_date IS NOT NULL THEN
2853: IF y_column LIKE 'CHARACTER%' THEN
2854: qltninrb.set_value(y_column,qltdate.date_to_canon(return_value_date));
2855: ELSE
2856: qltninrb.set_value(y_column,to_char(return_value_date));
2857: END IF;
2858: END IF;
2859: -- End of bug 7491253
2860: END;