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.OE_CONFIG_UTIL dependencies on CTO_CHANGE_ORDER_PK

Line 6769: l_cto_change_tbl CTO_CHANGE_ORDER_PK.CHANGE_TABLE_TYPE;

6765: IS
6766: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
6767: l_msg_count NUMBER;
6768: l_msg_data VARCHAR2(2000);
6769: l_cto_change_tbl CTO_CHANGE_ORDER_PK.CHANGE_TABLE_TYPE;
6770: l_ato_line_id NUMBER := p_ato_line_id;
6771: I NUMBER;
6772: l_split_tbl CTO_CHANGE_ORDER_PK.SPLIT_CHG_TABLE_TYPE;
6773: l_decimal_tbl CTO_CHANGE_ORDER_PK.OPTION_CHG_TABLE_TYPE;

Line 6772: l_split_tbl CTO_CHANGE_ORDER_PK.SPLIT_CHG_TABLE_TYPE;

6768: l_msg_data VARCHAR2(2000);
6769: l_cto_change_tbl CTO_CHANGE_ORDER_PK.CHANGE_TABLE_TYPE;
6770: l_ato_line_id NUMBER := p_ato_line_id;
6771: I NUMBER;
6772: l_split_tbl CTO_CHANGE_ORDER_PK.SPLIT_CHG_TABLE_TYPE;
6773: l_decimal_tbl CTO_CHANGE_ORDER_PK.OPTION_CHG_TABLE_TYPE;
6774:
6775: --
6776: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 6773: l_decimal_tbl CTO_CHANGE_ORDER_PK.OPTION_CHG_TABLE_TYPE;

6769: l_cto_change_tbl CTO_CHANGE_ORDER_PK.CHANGE_TABLE_TYPE;
6770: l_ato_line_id NUMBER := p_ato_line_id;
6771: I NUMBER;
6772: l_split_tbl CTO_CHANGE_ORDER_PK.SPLIT_CHG_TABLE_TYPE;
6773: l_decimal_tbl CTO_CHANGE_ORDER_PK.OPTION_CHG_TABLE_TYPE;
6774:
6775: --
6776: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6777: --

Line 6787: l_cto_change_tbl(I).change_type := CTO_CHANGE_ORDER_PK.QTY_CHANGE;

6783: I := 0;
6784:
6785: IF p_request_rec.param1 is not NULL THEN
6786: I := I + 1;
6787: l_cto_change_tbl(I).change_type := CTO_CHANGE_ORDER_PK.QTY_CHANGE;
6788: l_cto_change_tbl(I).old_value := p_request_rec.param1;
6789: l_cto_change_tbl(I).new_value := p_request_rec.param2;
6790: END IF;
6791:

Line 6794: l_cto_change_tbl(I).change_type := CTO_CHANGE_ORDER_PK.RD_CHANGE;

6790: END IF;
6791:
6792: IF p_request_rec.param3 is not NULL THEN
6793: I := I + 1;
6794: l_cto_change_tbl(I).change_type := CTO_CHANGE_ORDER_PK.RD_CHANGE;
6795: l_cto_change_tbl(I).old_value := p_request_rec.param3;
6796: l_cto_change_tbl(I).new_value := p_request_rec.param4;
6797: END IF;
6798:

Line 6801: l_cto_change_tbl(I).change_type := CTO_CHANGE_ORDER_PK.SSD_CHANGE;

6797: END IF;
6798:
6799: IF p_request_rec.param5 is not NULL THEN
6800: I := I + 1;
6801: l_cto_change_tbl(I).change_type := CTO_CHANGE_ORDER_PK.SSD_CHANGE;
6802: l_cto_change_tbl(I).old_value := p_request_rec.param5;
6803: l_cto_change_tbl(I).new_value := p_request_rec.param6;
6804: END IF;
6805:

Line 6808: l_cto_change_tbl(I).change_type := CTO_CHANGE_ORDER_PK.SAD_CHANGE;

6804: END IF;
6805:
6806: IF p_request_rec.param7 is not NULL THEN
6807: I := I + 1;
6808: l_cto_change_tbl(I).change_type := CTO_CHANGE_ORDER_PK.SAD_CHANGE;
6809: l_cto_change_tbl(I).old_value := p_request_rec.param7;
6810: l_cto_change_tbl(I).new_value := p_request_rec.param8;
6811: END IF;
6812:

Line 6815: l_cto_change_tbl(I).change_type := CTO_CHANGE_ORDER_PK.CONFIG_CHANGE;

6811: END IF;
6812:
6813: IF p_request_rec.param9 is not NULL THEN
6814: I := I + 1;
6815: l_cto_change_tbl(I).change_type := CTO_CHANGE_ORDER_PK.CONFIG_CHANGE;
6816: END IF;
6817:
6818: IF p_request_rec.param10 is not NULL THEN
6819: I := I + 1;

Line 6820: l_cto_change_tbl(I).change_type := CTO_CHANGE_ORDER_PK.WAREHOUSE_CHANGE;

6816: END IF;
6817:
6818: IF p_request_rec.param10 is not NULL THEN
6819: I := I + 1;
6820: l_cto_change_tbl(I).change_type := CTO_CHANGE_ORDER_PK.WAREHOUSE_CHANGE;
6821: l_cto_change_tbl(I).old_value := p_request_rec.param10;
6822: l_cto_change_tbl(I).new_value := p_request_rec.param11;
6823: END IF;
6824: -- INVCONV start

Line 6828: l_cto_change_tbl(I).change_type := CTO_CHANGE_ORDER_PK.QTY2_CHANGE;

6824: -- INVCONV start
6825:
6826: IF p_request_rec.param12 is not NULL THEN
6827: I := I + 1;
6828: l_cto_change_tbl(I).change_type := CTO_CHANGE_ORDER_PK.QTY2_CHANGE;
6829: l_cto_change_tbl(I).old_value := p_request_rec.param12;
6830: l_cto_change_tbl(I).new_value := p_request_rec.param13;
6831: END IF;
6832: IF l_debug_level > 0 THEN

Line 6837: l_cto_change_tbl(I).change_type := CTO_CHANGE_ORDER_PK.QTY2_UOM_CHANGE;

6833: oe_debug_pub.add('NOTIFY_CTO 3 ' , 1);
6834: END IF;
6835: IF p_request_rec.param14 is not NULL THEN
6836: I := I + 1;
6837: l_cto_change_tbl(I).change_type := CTO_CHANGE_ORDER_PK.QTY2_UOM_CHANGE;
6838: l_cto_change_tbl(I).old_value := p_request_rec.param14;
6839: l_cto_change_tbl(I).new_value := p_request_rec.param15;
6840: END IF;
6841: IF l_debug_level > 0 THEN

Line 6846: l_cto_change_tbl(I).change_type := CTO_CHANGE_ORDER_PK.QTY_UOM_CHANGE;

6842: oe_debug_pub.add('NOTIFY_CTO 4 ' , 1);
6843: END IF;
6844: IF p_request_rec.param16 is not NULL THEN
6845: I := I + 1;
6846: l_cto_change_tbl(I).change_type := CTO_CHANGE_ORDER_PK.QTY_UOM_CHANGE;
6847: l_cto_change_tbl(I).old_value := p_request_rec.param16;
6848: l_cto_change_tbl(I).new_value := p_request_rec.param17;
6849: END IF;
6850:

Line 6871: l_cto_change_tbl(I).change_type := CTO_CHANGE_ORDER_PK.CONFIG_CHANGE;

6867: IF l_debug_level > 0 THEN
6868: oe_debug_pub.add('part of PTO, but correct ato_line_id ', 3 );
6869: END IF;
6870:
6871: l_cto_change_tbl(I).change_type := CTO_CHANGE_ORDER_PK.CONFIG_CHANGE;
6872: l_cto_change_tbl(I).old_value := p_request_tbl(I).param1;
6873: l_cto_change_tbl(I).new_value := 'PTO_ATO_CREATE';
6874: l_ato_line_id := null;
6875: END IF;

Line 6929: CTO_CHANGE_ORDER_PK.CHANGE_NOTIFY

6925: END IF;
6926:
6927: IF l_cto_change_tbl.COUNT > 0 THEN
6928:
6929: CTO_CHANGE_ORDER_PK.CHANGE_NOTIFY
6930: ( plineid => l_ato_line_id
6931: ,pchgtype => l_cto_change_tbl
6932: ,poptionchgdtls => l_decimal_tbl
6933: ,psplitdtls => l_split_tbl