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 606: QLTNINRB.INIT_CURSOR(P_PLAN_ID, NULL, X_TXN_HEADER_ID, P_OCCURRENCE);

602: -- For Bug1843356. Added the IF condition below.
603: -- kabalakr 22 feb 02
604:
605: IF (P_OCCURRENCE IS NOT NULL) THEN
606: QLTNINRB.INIT_CURSOR(P_PLAN_ID, NULL, X_TXN_HEADER_ID, P_OCCURRENCE);
607: ELSIF nvl(X_PASSED_ID_NAME, 'TXN_HEADER_ID') = 'TXN_HEADER_ID' then
608: QLTNINRB.INIT_CURSOR(NULL, X_TXN_HEADER_ID, NULL, NULL);
609: ELSE
610: QLTNINRB.INIT_CURSOR(NULL, NULL, X_TXN_HEADER_ID, NULL) ;

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

604:
605: IF (P_OCCURRENCE IS NOT NULL) THEN
606: QLTNINRB.INIT_CURSOR(P_PLAN_ID, NULL, X_TXN_HEADER_ID, P_OCCURRENCE);
607: ELSIF nvl(X_PASSED_ID_NAME, 'TXN_HEADER_ID') = 'TXN_HEADER_ID' then
608: QLTNINRB.INIT_CURSOR(NULL, X_TXN_HEADER_ID, NULL, NULL);
609: ELSE
610: QLTNINRB.INIT_CURSOR(NULL, NULL, X_TXN_HEADER_ID, NULL) ;
611: END IF ;
612:

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

606: QLTNINRB.INIT_CURSOR(P_PLAN_ID, NULL, X_TXN_HEADER_ID, P_OCCURRENCE);
607: ELSIF nvl(X_PASSED_ID_NAME, 'TXN_HEADER_ID') = 'TXN_HEADER_ID' then
608: QLTNINRB.INIT_CURSOR(NULL, X_TXN_HEADER_ID, NULL, NULL);
609: ELSE
610: QLTNINRB.INIT_CURSOR(NULL, NULL, X_TXN_HEADER_ID, NULL) ;
611: END IF ;
612:
613: WHILE QLTNINRB.NEXT_ROW LOOP
614:

Line 613: WHILE QLTNINRB.NEXT_ROW LOOP

609: ELSE
610: QLTNINRB.INIT_CURSOR(NULL, NULL, X_TXN_HEADER_ID, NULL) ;
611: END IF ;
612:
613: WHILE QLTNINRB.NEXT_ROW LOOP
614:
615: -- get collection id, creation date, spec id and plan id
616: X_COLLECTION_ID := to_number(QLTNINRB.NAME_IN('COLLECTION_ID'));
617: --

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

612:
613: WHILE QLTNINRB.NEXT_ROW LOOP
614:
615: -- get collection id, creation date, spec id and plan id
616: X_COLLECTION_ID := to_number(QLTNINRB.NAME_IN('COLLECTION_ID'));
617: --
618: -- bug 12605910
619: -- The fnd function fnd_date.chardt_to_date has a bug because of which it gives
620: -- an error for Non gregorian dates. This was reported in bug 12813897.

Line 623: -- X_CREATION_DATE := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'), calendar_aware=> FND_DATE.calendar_aware_alt);

619: -- The fnd function fnd_date.chardt_to_date has a bug because of which it gives
620: -- an error for Non gregorian dates. This was reported in bug 12813897.
621: -- So bypassing it to use the SQL to_date function
622: --
623: -- X_CREATION_DATE := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'), calendar_aware=> FND_DATE.calendar_aware_alt);
624: X_CREATION_DATE := to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'),
625: l_user_date_mask ||' HH24:MI:SS',
626: 'NLS_CALENDAR='''||FND_DATE.user_calendar||'''');
627: Y_SPEC_ID := to_number(QLTNINRB.NAME_IN('SPEC_ID'));

Line 624: X_CREATION_DATE := to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'),

620: -- an error for Non gregorian dates. This was reported in bug 12813897.
621: -- So bypassing it to use the SQL to_date function
622: --
623: -- X_CREATION_DATE := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'), calendar_aware=> FND_DATE.calendar_aware_alt);
624: X_CREATION_DATE := to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'),
625: l_user_date_mask ||' HH24:MI:SS',
626: 'NLS_CALENDAR='''||FND_DATE.user_calendar||'''');
627: Y_SPEC_ID := to_number(QLTNINRB.NAME_IN('SPEC_ID'));
628: Y_PLAN_ID := to_number(QLTNINRB.NAME_IN('PLAN_ID'));

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

623: -- X_CREATION_DATE := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'), calendar_aware=> FND_DATE.calendar_aware_alt);
624: X_CREATION_DATE := to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'),
625: l_user_date_mask ||' HH24:MI:SS',
626: 'NLS_CALENDAR='''||FND_DATE.user_calendar||'''');
627: Y_SPEC_ID := to_number(QLTNINRB.NAME_IN('SPEC_ID'));
628: Y_PLAN_ID := to_number(QLTNINRB.NAME_IN('PLAN_ID'));
629:
630: -- Bug 5111269.
631: -- In EAM Transactions we are not supporting Specifications at plan level.

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

624: X_CREATION_DATE := to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'),
625: l_user_date_mask ||' HH24:MI:SS',
626: 'NLS_CALENDAR='''||FND_DATE.user_calendar||'''');
627: Y_SPEC_ID := to_number(QLTNINRB.NAME_IN('SPEC_ID'));
628: Y_PLAN_ID := to_number(QLTNINRB.NAME_IN('PLAN_ID'));
629:
630: -- Bug 5111269.
631: -- In EAM Transactions we are not supporting Specifications at plan level.
632: -- We support specifications at element level only. Since specifications is

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

675: if NVL(X_ARGUMENT,NULL) = 'IMPORT' THEN
676: BEGIN
677:
678: I := 0;
679: X_OCCURRENCE := TO_NUMBER(QLTNINRB.NAME_IN('OCCURRENCE'));
680: FOR UPDATED_RES_COLUMNS IN
681: (SELECT CHAR_ID
682: FROM QA_RESULTS_UPDATE_HISTORY
683: WHERE TXN_HEADER_ID = X_TXN_HEADER_ID

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

780: -- comparison can be evaluated. Checking FK_LOOKUP_TYPE locally
781: -- saves us an unnecessary database hit.
782: IF fk_type_tab(i) in (0, 1, 3)
783: THEN result := QLTSMENB.LOOKUP(char_id_tab(i),
784: QLTNINRB.NAME_IN(column_tab(i)));
785: ELSE result := QLTNINRB.NAME_IN(column_tab(i));
786: END IF;
787: done := FALSE;
788:

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

781: -- saves us an unnecessary database hit.
782: IF fk_type_tab(i) in (0, 1, 3)
783: THEN result := QLTSMENB.LOOKUP(char_id_tab(i),
784: QLTNINRB.NAME_IN(column_tab(i)));
785: ELSE result := QLTNINRB.NAME_IN(column_tab(i));
786: END IF;
787: done := FALSE;
788:
789: -- Added for update capabilities...

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

862: operator_tab(i),low_value_tab(i),
863: high_value_tab(i),X_message,
864: result,X_CONCURRENT);
865: END IF;
866: output := to_number(QLTNINRB.NAME_IN('WIP_ENTITY_ID'));
867: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
868:
869: -- call WIP api
870: BEGIN

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

863: high_value_tab(i),X_message,
864: result,X_CONCURRENT);
865: END IF;
866: output := to_number(QLTNINRB.NAME_IN('WIP_ENTITY_ID'));
867: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
868:
869: -- call WIP api
870: BEGIN
871: WIP_CHANGE_STATUS.PUT_JOB_ON_HOLD(output, X_org_id);

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

900: OPEN MY_STEP(Y_PLAN_ID);
901: FETCH MY_STEP INTO RES_COL_NAME;
902: CLOSE MY_STEP;
903:
904: output := to_number(QLTNINRB.NAME_IN('WIP_ENTITY_ID'));
905: output2 := to_number(QLTNINRB.NAME_IN('LINE_ID'));
906: output3 := to_number(QLTNINRB.NAME_IN('TO_OP_SEQ_NUM'));
907: INTEROP_STEP := QLTNINRB.NAME_IN(RES_COL_NAME);
908:

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

901: FETCH MY_STEP INTO RES_COL_NAME;
902: CLOSE MY_STEP;
903:
904: output := to_number(QLTNINRB.NAME_IN('WIP_ENTITY_ID'));
905: output2 := to_number(QLTNINRB.NAME_IN('LINE_ID'));
906: output3 := to_number(QLTNINRB.NAME_IN('TO_OP_SEQ_NUM'));
907: INTEROP_STEP := QLTNINRB.NAME_IN(RES_COL_NAME);
908:
909: OPEN MY_STEP_LOOKUP(INTEROP_STEP);

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

902: CLOSE MY_STEP;
903:
904: output := to_number(QLTNINRB.NAME_IN('WIP_ENTITY_ID'));
905: output2 := to_number(QLTNINRB.NAME_IN('LINE_ID'));
906: output3 := to_number(QLTNINRB.NAME_IN('TO_OP_SEQ_NUM'));
907: INTEROP_STEP := QLTNINRB.NAME_IN(RES_COL_NAME);
908:
909: OPEN MY_STEP_LOOKUP(INTEROP_STEP);
910: FETCH MY_STEP_LOOKUP INTO output4;

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

903:
904: output := to_number(QLTNINRB.NAME_IN('WIP_ENTITY_ID'));
905: output2 := to_number(QLTNINRB.NAME_IN('LINE_ID'));
906: output3 := to_number(QLTNINRB.NAME_IN('TO_OP_SEQ_NUM'));
907: INTEROP_STEP := QLTNINRB.NAME_IN(RES_COL_NAME);
908:
909: OPEN MY_STEP_LOOKUP(INTEROP_STEP);
910: FETCH MY_STEP_LOOKUP INTO output4;
911: CLOSE MY_STEP_LOOKUP;

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

909: OPEN MY_STEP_LOOKUP(INTEROP_STEP);
910: FETCH MY_STEP_LOOKUP INTO output4;
911: CLOSE MY_STEP_LOOKUP;
912:
913: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
914:
915: -- call WIP api
916: BEGIN
917: WIP_SF_STATUS.ATTACH(output,X_org_id,output2,

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

942: FETCH MY_STATUS_ID INTO X_STATUS_ID;
943: CLOSE MY_STATUS_ID;
944:
945: -- get the org id, lot number and item id
946: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
947: X_lot_number := QLTNINRB.NAME_IN('LOT_NUMBER');
948: X_Item_id := to_number (QLTNINRB.Name_in('ITEM_ID' )) ;
949:
950: -- call Inventory API

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

943: CLOSE MY_STATUS_ID;
944:
945: -- get the org id, lot number and item id
946: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
947: X_lot_number := QLTNINRB.NAME_IN('LOT_NUMBER');
948: X_Item_id := to_number (QLTNINRB.Name_in('ITEM_ID' )) ;
949:
950: -- call Inventory API
951: BEGIN

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

944:
945: -- get the org id, lot number and item id
946: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
947: X_lot_number := QLTNINRB.NAME_IN('LOT_NUMBER');
948: X_Item_id := to_number (QLTNINRB.Name_in('ITEM_ID' )) ;
949:
950: -- call Inventory API
951: BEGIN
952: INV_MATERIAL_STATUS_GRP.UPDATE_STATUS(

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

1002: FETCH MY_STATUS_ID INTO X_STATUS_ID;
1003: CLOSE MY_STATUS_ID;
1004:
1005: -- get the org id, serial number and item id
1006: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1007: X_serial_number := QLTNINRB.NAME_IN('SERIAL_NUMBER');
1008: X_Item_id := to_number (QLTNINRB.Name_in('ITEM_ID' )) ;
1009:
1010: -- call Inventory API

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

1003: CLOSE MY_STATUS_ID;
1004:
1005: -- get the org id, serial number and item id
1006: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1007: X_serial_number := QLTNINRB.NAME_IN('SERIAL_NUMBER');
1008: X_Item_id := to_number (QLTNINRB.Name_in('ITEM_ID' )) ;
1009:
1010: -- call Inventory API
1011: BEGIN

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

1004:
1005: -- get the org id, serial number and item id
1006: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1007: X_serial_number := QLTNINRB.NAME_IN('SERIAL_NUMBER');
1008: X_Item_id := to_number (QLTNINRB.Name_in('ITEM_ID' )) ;
1009:
1010: -- call Inventory API
1011: BEGIN
1012: INV_MATERIAL_STATUS_GRP.UPDATE_STATUS(

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

1060: X_CREATION_DATE,0,
1061: 0,'',
1062: '',X_message,
1063: '',X_CONCURRENT);
1064: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1065: X_Vendor_id := to_number(QLTNINRB.NAME_IN('VENDOR_ID'));
1066:
1067: -- get the operating unit
1068: OPEN MY_OP_UNIT(X_ORG_ID);

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

1061: 0,'',
1062: '',X_message,
1063: '',X_CONCURRENT);
1064: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1065: X_Vendor_id := to_number(QLTNINRB.NAME_IN('VENDOR_ID'));
1066:
1067: -- get the operating unit
1068: OPEN MY_OP_UNIT(X_ORG_ID);
1069: FETCH MY_OP_UNIT INTO X_OP_UNIT;

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

1098: '',X_message,
1099: '',X_CONCURRENT);
1100: BEGIN
1101: retnum := PO_DOCUMENT_ACTIONS_SV.PO_HOLD_DOCUMENT(
1102: to_number(QLTNINRB.NAME_IN('PO_HEADER_ID')),
1103: to_number(QLTNINRB.NAME_IN('PO_RELEASE_ID')),
1104: x_msg_data);
1105: IF retnum <> 0 THEN
1106: RAISE po_api_failed;

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

1099: '',X_CONCURRENT);
1100: BEGIN
1101: retnum := PO_DOCUMENT_ACTIONS_SV.PO_HOLD_DOCUMENT(
1102: to_number(QLTNINRB.NAME_IN('PO_HEADER_ID')),
1103: to_number(QLTNINRB.NAME_IN('PO_RELEASE_ID')),
1104: x_msg_data);
1105: IF retnum <> 0 THEN
1106: RAISE po_api_failed;
1107: END IF;

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

1125: X_CREATION_DATE,0,
1126: 0,'',
1127: '',X_message,
1128: '',X_CONCURRENT);
1129: output := to_number(QLTNINRB.NAME_IN('WIP_ENTITY_ID'));
1130: output2 := to_number(QLTNINRB.NAME_IN('LINE_ID'));
1131: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1132:
1133: -- AG: QWB: wip_entity_id is needed to put the schedule on hold.

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

1126: 0,'',
1127: '',X_message,
1128: '',X_CONCURRENT);
1129: output := to_number(QLTNINRB.NAME_IN('WIP_ENTITY_ID'));
1130: output2 := to_number(QLTNINRB.NAME_IN('LINE_ID'));
1131: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1132:
1133: -- AG: QWB: wip_entity_id is needed to put the schedule on hold.
1134: IF output IS NULL THEN

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

1127: '',X_message,
1128: '',X_CONCURRENT);
1129: output := to_number(QLTNINRB.NAME_IN('WIP_ENTITY_ID'));
1130: output2 := to_number(QLTNINRB.NAME_IN('LINE_ID'));
1131: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1132:
1133: -- AG: QWB: wip_entity_id is needed to put the schedule on hold.
1134: IF output IS NULL THEN
1135: BEGIN

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

1139: WHERE wrs.organization_id = x_org_id
1140: AND wrs.line_id = output2
1141: AND we.wip_entity_id = wrs.wip_entity_id
1142: AND we.organization_id = wrs.organization_id
1143: AND we.primary_item_id = to_number(QLTNINRB.NAME_IN('ITEM_ID'));
1144: EXCEPTION
1145: WHEN OTHERS THEN
1146: NULL;
1147: END;

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

1176: X_CREATION_DATE,0,
1177: 0,'',
1178: '',X_message,
1179: '',X_CONCURRENT);
1180: X_OCCURRENCE := to_number(QLTNINRB.NAME_IN('OCCURRENCE'));
1181:
1182: OPEN MY_ASSIGNED_CHAR_ID(pca_id_tab(i), action_id_tab(i));
1183: FETCH MY_ASSIGNED_CHAR_ID INTO X_ASSIGNED_CHAR_ID;
1184: CLOSE MY_ASSIGNED_CHAR_ID;

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

1221: ELSIF action_id_tab(i) in (25, 26) AND
1222: x_action_type = 'IMMEDIATE' THEN
1223: x_progress := 2;
1224: X_TRANSACTION_NUMBER :=
1225: to_number(QLTNINRB.NAME_IN('TRANSACTION_NUMBER'));
1226:
1227: -- only allow action if from inspection transaction
1228:
1229: --

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

1257: '',X_message,
1258: '',X_CONCURRENT);
1259: END IF;
1260:
1261: X_TRANSACTION_ID := QLTNINRB.NAME_IN('TRANSACTION_ID');
1262:
1263: x_progress := 3;
1264: IF X_TRANSACTION_ID IS NULL THEN
1265: x_progress := 4;

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

1266: RAISE null_txn_id;
1267: END IF;
1268:
1269: x_progress := 5;
1270: X_LAST_UPDATED_BY := QLTNINRB.NAME_IN('LAST_UPDATED_BY');
1271: X_LOGIN := QLTNINRB.NAME_IN('LAST_UPDATE_LOGIN');
1272: OPEN MY_RESULTS_COLUMN(Y_PLAN_ID);
1273:
1274: -- loop through collection elements, extracting

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

1267: END IF;
1268:
1269: x_progress := 5;
1270: X_LAST_UPDATED_BY := QLTNINRB.NAME_IN('LAST_UPDATED_BY');
1271: X_LOGIN := QLTNINRB.NAME_IN('LAST_UPDATE_LOGIN');
1272: OPEN MY_RESULTS_COLUMN(Y_PLAN_ID);
1273:
1274: -- loop through collection elements, extracting
1275: -- the ones required for the action

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

1276: LOOP
1277: FETCH MY_RESULTS_COLUMN INTO RC;
1278: EXIT WHEN MY_RESULTS_COLUMN%NOTFOUND;
1279:
1280: result_value := QLTNINRB.NAME_IN(RC.Q_COLUMN);
1281: IF RC.DEV_NAME = 'TRANSACTION_DATE' THEN
1282: X_TRANSACTION_DATE := qltdate.any_to_date(result_value);
1283: ELSIF RC.DEV_NAME = 'QUANTITY' THEN
1284: X_QUANTITY := result_value;

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

1336:
1337: -- Fetching the value of org_id. For RCV/WMS project.
1338: -- Bug 3096256. kabalakr Mon Aug 18 03:18:19 PDT 2003.
1339:
1340: X_ORG_ID := TO_NUMBER(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1341:
1342:
1343: IF X_TRANSACTION_DATE IS NULL OR
1344: X_QUANTITY IS NULL OR

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

1746:
1747:
1748: --Create work request added by kaza
1749: ELSIF action_id_tab(i) = 29 and nvl(x_action_type, 'DEFERRED') = 'DEFERRED' THEN
1750: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1751: X_OCCURRENCE := to_number(QLTNINRB.NAME_IN('OCCURRENCE'));
1752: --dgupta: Start R12 EAM Integration. Bug 4345492
1753: X_ASSET_INSTANCE_ID := QLTNINRB.NAME_IN('ASSET_INSTANCE_ID');
1754: if (X_ASSET_INSTANCE_ID is null) then

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

1747:
1748: --Create work request added by kaza
1749: ELSIF action_id_tab(i) = 29 and nvl(x_action_type, 'DEFERRED') = 'DEFERRED' THEN
1750: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1751: X_OCCURRENCE := to_number(QLTNINRB.NAME_IN('OCCURRENCE'));
1752: --dgupta: Start R12 EAM Integration. Bug 4345492
1753: X_ASSET_INSTANCE_ID := QLTNINRB.NAME_IN('ASSET_INSTANCE_ID');
1754: if (X_ASSET_INSTANCE_ID is null) then
1755: X_ASSET_GROUP_ID := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));

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

1749: ELSIF action_id_tab(i) = 29 and nvl(x_action_type, 'DEFERRED') = 'DEFERRED' THEN
1750: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1751: X_OCCURRENCE := to_number(QLTNINRB.NAME_IN('OCCURRENCE'));
1752: --dgupta: Start R12 EAM Integration. Bug 4345492
1753: X_ASSET_INSTANCE_ID := QLTNINRB.NAME_IN('ASSET_INSTANCE_ID');
1754: if (X_ASSET_INSTANCE_ID is null) then
1755: X_ASSET_GROUP_ID := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));
1756: X_ASSET_NUMBER := QLTNINRB.NAME_IN('ASSET_NUMBER');
1757: end if;

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

1751: X_OCCURRENCE := to_number(QLTNINRB.NAME_IN('OCCURRENCE'));
1752: --dgupta: Start R12 EAM Integration. Bug 4345492
1753: X_ASSET_INSTANCE_ID := QLTNINRB.NAME_IN('ASSET_INSTANCE_ID');
1754: if (X_ASSET_INSTANCE_ID is null) then
1755: X_ASSET_GROUP_ID := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));
1756: X_ASSET_NUMBER := QLTNINRB.NAME_IN('ASSET_NUMBER');
1757: end if;
1758: --dgupta: End R12 EAM Integration. Bug 4345492
1759:

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

1752: --dgupta: Start R12 EAM Integration. Bug 4345492
1753: X_ASSET_INSTANCE_ID := QLTNINRB.NAME_IN('ASSET_INSTANCE_ID');
1754: if (X_ASSET_INSTANCE_ID is null) then
1755: X_ASSET_GROUP_ID := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));
1756: X_ASSET_NUMBER := QLTNINRB.NAME_IN('ASSET_NUMBER');
1757: end if;
1758: --dgupta: End R12 EAM Integration. Bug 4345492
1759:
1760: -- check to see if priority element exists in the plan

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

1767: OPEN Get_result_column_name (ELEMENT_ID, Y_PLAN_ID);
1768: FETCH Get_result_column_name INTO Priority_soft_column;
1769: CLOSE Get_result_column_name;
1770:
1771: Priority_value := QLTNINRB.NAME_IN(Priority_soft_column);
1772:
1773: if (Priority_value is not null) then
1774: OPEN Get_priority_id (Priority_value);
1775: FETCH Get_priority_id INTO Priority_id;

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

1868:
1869:
1870: ELSIF action_id_tab(i) = 30 and nvl(x_action_type, 'DEFERRED') = 'DEFERRED' THEN
1871:
1872: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1873: --dgupta: Start R12 EAM Integration. Bug 4345492
1874: X_ASSET_INSTANCE_ID := QLTNINRB.NAME_IN('ASSET_INSTANCE_ID');
1875: X_ASSET_GROUP_ID := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));
1876:

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

1870: ELSIF action_id_tab(i) = 30 and nvl(x_action_type, 'DEFERRED') = 'DEFERRED' THEN
1871:
1872: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1873: --dgupta: Start R12 EAM Integration. Bug 4345492
1874: X_ASSET_INSTANCE_ID := QLTNINRB.NAME_IN('ASSET_INSTANCE_ID');
1875: X_ASSET_GROUP_ID := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));
1876:
1877: if (X_ASSET_INSTANCE_ID is not null) then
1878: -- Bug 8849343.Made changes to make this action capable of creating work orders

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

1871:
1872: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
1873: --dgupta: Start R12 EAM Integration. Bug 4345492
1874: X_ASSET_INSTANCE_ID := QLTNINRB.NAME_IN('ASSET_INSTANCE_ID');
1875: X_ASSET_GROUP_ID := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));
1876:
1877: if (X_ASSET_INSTANCE_ID is not null) then
1878: -- Bug 8849343.Made changes to make this action capable of creating work orders
1879: -- for serialised and non-serialised rebuildable work orders.

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

1881: -- ntungare
1882: OPEN Get_eam_item_type(X_org_id, X_ASSET_INSTANCE_ID);
1883: FETCH Get_eam_item_type INTO l_eam_item_type;
1884: CLOSE Get_eam_item_type;
1885: X_ASSET_NUMBER := QLTNINRB.NAME_IN('ASSET_NUMBER');
1886:
1887: l_work_order_rec.maintenance_object_id := X_ASSET_INSTANCE_ID;
1888: l_work_order_rec.maintenance_object_type := 3;
1889:

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

1907: l_work_order_rec.manual_rebuild_flag := 'Y';
1908: l_work_order_rec.maintenance_object_type := 2;
1909:
1910: /*
1911: X_ASSET_GROUP_ID := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));
1912: X_ASSET_NUMBER := QLTNINRB.NAME_IN('ASSET_NUMBER');
1913: if (X_ASSET_GROUP_ID is not null and X_ASSET_NUMBER is null) then
1914: l_work_order_rec.maintenance_object_id := X_ASSET_GROUP_ID;
1915: l_work_order_rec.rebuild_item_id :=X_ASSET_GROUP_ID;

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

1908: l_work_order_rec.maintenance_object_type := 2;
1909:
1910: /*
1911: X_ASSET_GROUP_ID := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));
1912: X_ASSET_NUMBER := QLTNINRB.NAME_IN('ASSET_NUMBER');
1913: if (X_ASSET_GROUP_ID is not null and X_ASSET_NUMBER is null) then
1914: l_work_order_rec.maintenance_object_id := X_ASSET_GROUP_ID;
1915: l_work_order_rec.rebuild_item_id :=X_ASSET_GROUP_ID;
1916: l_work_order_rec.maintenance_object_type := 2;

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

1917: elsif (X_ASSET_GROUP_ID is not null) then
1918: l_work_order_rec.maintenance_object_id :=
1919: qa_plan_element_api.get_asset_instance_id(X_ASSET_GROUP_ID, X_ASSET_NUMBER);
1920: l_work_order_rec.maintenance_object_type := 3;
1921: l_work_order_rec.asset_group_id := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));
1922: l_work_order_rec.asset_number := QLTNINRB.NAME_IN('ASSET_NUMBER');
1923:
1924: end if;*/
1925: end if;

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

1918: l_work_order_rec.maintenance_object_id :=
1919: qa_plan_element_api.get_asset_instance_id(X_ASSET_GROUP_ID, X_ASSET_NUMBER);
1920: l_work_order_rec.maintenance_object_type := 3;
1921: l_work_order_rec.asset_group_id := to_number(QLTNINRB.NAME_IN('ASSET_GROUP_ID'));
1922: l_work_order_rec.asset_number := QLTNINRB.NAME_IN('ASSET_NUMBER');
1923:
1924: end if;*/
1925: end if;
1926:

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

1923:
1924: end if;*/
1925: end if;
1926:
1927: l_followup_activity_id := QLTNINRB.NAME_IN('FOLLOWUP_ACTIVITY_ID');
1928: --dgupta: End R12 EAM Integration. Bug 4345492
1929: l_work_order_rec.primary_item_id := l_followup_activity_id;
1930:
1931: l_work_order_rec.last_update_date := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'), calendar_aware=> FND_DATE.calendar_aware_alt);

Line 1931: l_work_order_rec.last_update_date := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'), calendar_aware=> FND_DATE.calendar_aware_alt);

1927: l_followup_activity_id := QLTNINRB.NAME_IN('FOLLOWUP_ACTIVITY_ID');
1928: --dgupta: End R12 EAM Integration. Bug 4345492
1929: l_work_order_rec.primary_item_id := l_followup_activity_id;
1930:
1931: l_work_order_rec.last_update_date := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'), calendar_aware=> FND_DATE.calendar_aware_alt);
1932: l_work_order_rec.last_updated_by := QLTNINRB.NAME_IN('LAST_UPDATED_BY');
1933: l_work_order_rec.creation_date := x_creation_date;
1934: l_work_order_rec.created_by := QLTNINRB.NAME_IN('CREATED_BY');
1935: l_work_order_rec.last_update_login := QLTNINRB.NAME_IN('LAST_UPDATE_LOGIN');

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

1928: --dgupta: End R12 EAM Integration. Bug 4345492
1929: l_work_order_rec.primary_item_id := l_followup_activity_id;
1930:
1931: l_work_order_rec.last_update_date := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'), calendar_aware=> FND_DATE.calendar_aware_alt);
1932: l_work_order_rec.last_updated_by := QLTNINRB.NAME_IN('LAST_UPDATED_BY');
1933: l_work_order_rec.creation_date := x_creation_date;
1934: l_work_order_rec.created_by := QLTNINRB.NAME_IN('CREATED_BY');
1935: l_work_order_rec.last_update_login := QLTNINRB.NAME_IN('LAST_UPDATE_LOGIN');
1936:

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

1930:
1931: l_work_order_rec.last_update_date := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'), calendar_aware=> FND_DATE.calendar_aware_alt);
1932: l_work_order_rec.last_updated_by := QLTNINRB.NAME_IN('LAST_UPDATED_BY');
1933: l_work_order_rec.creation_date := x_creation_date;
1934: l_work_order_rec.created_by := QLTNINRB.NAME_IN('CREATED_BY');
1935: l_work_order_rec.last_update_login := QLTNINRB.NAME_IN('LAST_UPDATE_LOGIN');
1936:
1937: l_work_order_rec.organization_id := X_org_id;
1938: l_work_order_rec.load_type := 7;

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

1931: l_work_order_rec.last_update_date := fnd_date.chardt_to_date(QLTNINRB.NAME_IN('QA_CREATION_DATE'), calendar_aware=> FND_DATE.calendar_aware_alt);
1932: l_work_order_rec.last_updated_by := QLTNINRB.NAME_IN('LAST_UPDATED_BY');
1933: l_work_order_rec.creation_date := x_creation_date;
1934: l_work_order_rec.created_by := QLTNINRB.NAME_IN('CREATED_BY');
1935: l_work_order_rec.last_update_login := QLTNINRB.NAME_IN('LAST_UPDATE_LOGIN');
1936:
1937: l_work_order_rec.organization_id := X_org_id;
1938: l_work_order_rec.load_type := 7;
1939: l_work_order_rec.wip_supply_type := 7;

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

2000: OPEN MY_STATUS(pca_id_tab(i));
2001: FETCH MY_STATUS INTO X_STATUS;
2002: CLOSE MY_STATUS ;
2003: -- get the vendor , item and org id
2004: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
2005: X_Vendor_id := to_number(QLTNINRB.NAME_IN('VENDOR_ID'));
2006: X_Item_id := to_number (QLTNINRB.Name_in('ITEM_ID' )) ;
2007:
2008: -- call PO API

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

2001: FETCH MY_STATUS INTO X_STATUS;
2002: CLOSE MY_STATUS ;
2003: -- get the vendor , item and org id
2004: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
2005: X_Vendor_id := to_number(QLTNINRB.NAME_IN('VENDOR_ID'));
2006: X_Item_id := to_number (QLTNINRB.Name_in('ITEM_ID' )) ;
2007:
2008: -- call PO API
2009: BEGIN

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

2002: CLOSE MY_STATUS ;
2003: -- get the vendor , item and org id
2004: X_org_id := to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID'));
2005: X_Vendor_id := to_number(QLTNINRB.NAME_IN('VENDOR_ID'));
2006: X_Item_id := to_number (QLTNINRB.Name_in('ITEM_ID' )) ;
2007:
2008: -- call PO API
2009: BEGIN
2010: PO_ASL_SV.Update_Vendor_Status (x_org_id, x_vendor_id,

Line 2072: QLTNINRB.CLOSE_CURSOR;

2068: -- end of bug 13915679
2069:
2070: END LOOP; -- i <= total_rows
2071:
2072: QLTNINRB.CLOSE_CURSOR;
2073: RETURN(X_ERROR);
2074:
2075: EXCEPTION
2076:

Line 2079: QLTNINRB.CLOSE_CURSOR;

2075: EXCEPTION
2076:
2077: When Others THEN
2078: --dbms_output.put_line('x progress is '||to_char(x_progress));
2079: QLTNINRB.CLOSE_CURSOR;
2080: raise;
2081: END DO_ACTIONS;
2082:
2083:

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

2230: */
2231:
2232: token_datatype := prec.datatype;
2233:
2234: token_value := QLTNINRB.NAME_IN(prec.Q_COLUMN);
2235:
2236: -- Convert all normalized element ID's into its values.
2237: -- ex. Item_id,locator_id converted to item_name, locator respectively
2238: -- For performance reason, dont call qltsmenb for char_id 2,39

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

2393: FETCH ACTION_SET_NAME INTO X_ACTION_SET_NAME;
2394: close ACTION_SET_NAME;
2395:
2396: -- suramasw.Bug 2921276.Wed Jul 30 05:15:40 PDT 2003
2397: l_occurrence := TO_NUMBER(QLTNINRB.NAME_IN('OCCURRENCE'));
2398:
2399: -- Next we get any outputs to the alert
2400: FOR prec in OUTPUTS LOOP
2401: i := i + 1;

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

2398:
2399: -- Next we get any outputs to the alert
2400: FOR prec in OUTPUTS LOOP
2401: i := i + 1;
2402: ACTUAL_OUTPUT := QLTNINRB.NAME_IN(prec.Q_COLUMN);
2403: IF (prec.LOOKUP_TYPE = 0) or (prec.LOOKUP_TYPE = 1) or
2404: (prec.LOOKUP_TYPE = 3) THEN
2405: ACTUAL_OUTPUT := QLTSMENB.LOOKUP(prec.CHAR_ID, ACTUAL_OUTPUT);
2406: end IF;

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

2603: -- ntungare
2604: --
2605: -- IF assigned_col = 'ITEM_ID' THEN
2606: IF assigned_col IN ( 'ITEM_ID', 'COMP_ITEM_ID') THEN
2607: denorm_val := to_char(QA_FLEX_UTIL.get_item_id(to_number(QLTNINRB.NAME_IN('ORGANIZATION_ID')),denorm_val));
2608: ELSIF assigned_col = 'VENDOR_ID' THEN
2609: denorm_val := qa_plan_element_api.get_supplier_id(denorm_val);
2610: END IF;
2611: END;

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

2747: FOR prec in OUTPUTS LOOP
2748: EXIT WHEN find_token;
2749: IF UPPER(token_name) = UPPER(prec.token_name) THEN
2750: token_char_id := prec.char_id;
2751: token_column_value := QLTNINRB.NAME_IN(prec.Q_COLUMN);
2752: IF (prec.LOOKUP_TYPE = 0) or (prec.LOOKUP_TYPE = 1) or
2753: (prec.LOOKUP_TYPE = 3) THEN
2754: token_column_value := QLTSMENB.LOOKUP(prec.CHAR_ID,
2755: token_column_value);

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

2965: -- Added this if-else ladder to update the record in session
2966: -- in order to fire the cascaded actions.
2967: -- skolluku
2968: IF y_datatype IN (1,4) AND (return_value_char IS NOT NULL) THEN
2969: qltninrb.set_value(y_column,return_value_char);
2970: END IF;
2971: IF y_datatype=2 and return_value_num is not null then
2972: qltninrb.set_value(y_column,to_char(return_value_num));
2973: END IF;

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

2968: IF y_datatype IN (1,4) AND (return_value_char IS NOT NULL) THEN
2969: qltninrb.set_value(y_column,return_value_char);
2970: END IF;
2971: IF y_datatype=2 and return_value_num is not null then
2972: qltninrb.set_value(y_column,to_char(return_value_num));
2973: END IF;
2974: IF y_datatype = 6 and return_value_date is not null then
2975: IF y_column LIKE 'CHARACTER%' THEN
2976: qltninrb.set_value(y_column,qltdate.date_to_canon_dt(return_value_date));

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

2972: qltninrb.set_value(y_column,to_char(return_value_num));
2973: END IF;
2974: IF y_datatype = 6 and return_value_date is not null then
2975: IF y_column LIKE 'CHARACTER%' THEN
2976: qltninrb.set_value(y_column,qltdate.date_to_canon_dt(return_value_date));
2977: ELSE
2978: qltninrb.set_value(y_column,to_char(return_value_date));
2979: END IF;
2980: END IF;

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

2974: IF y_datatype = 6 and return_value_date is not null then
2975: IF y_column LIKE 'CHARACTER%' THEN
2976: qltninrb.set_value(y_column,qltdate.date_to_canon_dt(return_value_date));
2977: ELSE
2978: qltninrb.set_value(y_column,to_char(return_value_date));
2979: END IF;
2980: END IF;
2981: IF y_datatype = 3 AND return_value_date IS NOT NULL THEN
2982: IF y_column LIKE 'CHARACTER%' THEN

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

2979: END IF;
2980: END IF;
2981: IF y_datatype = 3 AND return_value_date IS NOT NULL THEN
2982: IF y_column LIKE 'CHARACTER%' THEN
2983: qltninrb.set_value(y_column,qltdate.date_to_canon(return_value_date));
2984: ELSE
2985: qltninrb.set_value(y_column,to_char(return_value_date));
2986: END IF;
2987: END IF;

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

2981: IF y_datatype = 3 AND return_value_date IS NOT NULL THEN
2982: IF y_column LIKE 'CHARACTER%' THEN
2983: qltninrb.set_value(y_column,qltdate.date_to_canon(return_value_date));
2984: ELSE
2985: qltninrb.set_value(y_column,to_char(return_value_date));
2986: END IF;
2987: END IF;
2988: -- End of bug 7491253
2989: END;