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.RCV_DEFAULT_PKG dependencies on RCV_TRANSACTIONS_INTERFACE

Line 794: p_customer_item_num IN rcv_transactions_interface.customer_item_num%TYPE,

790: RETURN NULL;
791: END get_sfloc_id_from_code;
792:
793: FUNCTION get_customer_item_id_from_num(
794: p_customer_item_num IN rcv_transactions_interface.customer_item_num%TYPE,
795: p_customer_id IN rcv_transactions_interface.customer_id%TYPE,
796: p_column IN VARCHAR2,
797: p_marker IN OUT NOCOPY BOOLEAN
798: )

Line 795: p_customer_id IN rcv_transactions_interface.customer_id%TYPE,

791: END get_sfloc_id_from_code;
792:
793: FUNCTION get_customer_item_id_from_num(
794: p_customer_item_num IN rcv_transactions_interface.customer_item_num%TYPE,
795: p_customer_id IN rcv_transactions_interface.customer_id%TYPE,
796: p_column IN VARCHAR2,
797: p_marker IN OUT NOCOPY BOOLEAN
798: )
799: RETURN rcv_transactions_interface.customer_item_id%TYPE IS

Line 799: RETURN rcv_transactions_interface.customer_item_id%TYPE IS

795: p_customer_id IN rcv_transactions_interface.customer_id%TYPE,
796: p_column IN VARCHAR2,
797: p_marker IN OUT NOCOPY BOOLEAN
798: )
799: RETURN rcv_transactions_interface.customer_item_id%TYPE IS
800: x_customer_item_id rcv_transactions_interface.customer_item_id%TYPE;
801: BEGIN
802: p_marker := FALSE;
803:

Line 800: x_customer_item_id rcv_transactions_interface.customer_item_id%TYPE;

796: p_column IN VARCHAR2,
797: p_marker IN OUT NOCOPY BOOLEAN
798: )
799: RETURN rcv_transactions_interface.customer_item_id%TYPE IS
800: x_customer_item_id rcv_transactions_interface.customer_item_id%TYPE;
801: BEGIN
802: p_marker := FALSE;
803:
804: IF ( p_customer_item_num IS NULL

Line 829: p_customer_item_id IN rcv_transactions_interface.customer_item_id%TYPE,

825: RETURN NULL;
826: END get_customer_item_id_from_num;
827:
828: FUNCTION get_customer_item_num_from_id(
829: p_customer_item_id IN rcv_transactions_interface.customer_item_id%TYPE,
830: p_column IN VARCHAR2,
831: p_marker IN OUT NOCOPY BOOLEAN
832: )
833: RETURN rcv_transactions_interface.customer_item_num%TYPE IS

Line 833: RETURN rcv_transactions_interface.customer_item_num%TYPE IS

829: p_customer_item_id IN rcv_transactions_interface.customer_item_id%TYPE,
830: p_column IN VARCHAR2,
831: p_marker IN OUT NOCOPY BOOLEAN
832: )
833: RETURN rcv_transactions_interface.customer_item_num%TYPE IS
834: x_customer_item_num rcv_transactions_interface.customer_item_num%TYPE;
835: BEGIN
836: p_marker := FALSE;
837:

Line 834: x_customer_item_num rcv_transactions_interface.customer_item_num%TYPE;

830: p_column IN VARCHAR2,
831: p_marker IN OUT NOCOPY BOOLEAN
832: )
833: RETURN rcv_transactions_interface.customer_item_num%TYPE IS
834: x_customer_item_num rcv_transactions_interface.customer_item_num%TYPE;
835: BEGIN
836: p_marker := FALSE;
837:
838: IF (p_customer_item_id IS NULL) THEN

Line 862: p_item_description IN rcv_transactions_interface.item_description%TYPE,

858: B. An One Time Item's description could match a description of a defined Item.
859:
860:
861: FUNCTION get_item_id_from_description(
862: p_item_description IN rcv_transactions_interface.item_description%TYPE,
863: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,
864: p_column IN VARCHAR2,
865: p_marker IN OUT NOCOPY BOOLEAN
866: )

Line 863: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,

859:
860:
861: FUNCTION get_item_id_from_description(
862: p_item_description IN rcv_transactions_interface.item_description%TYPE,
863: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,
864: p_column IN VARCHAR2,
865: p_marker IN OUT NOCOPY BOOLEAN
866: )
867: RETURN rcv_transactions_interface.item_id%TYPE IS

Line 867: RETURN rcv_transactions_interface.item_id%TYPE IS

863: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,
864: p_column IN VARCHAR2,
865: p_marker IN OUT NOCOPY BOOLEAN
866: )
867: RETURN rcv_transactions_interface.item_id%TYPE IS
868: x_item_id rcv_transactions_interface.item_id%TYPE;
869: BEGIN
870: p_marker := FALSE;
871:

Line 868: x_item_id rcv_transactions_interface.item_id%TYPE;

864: p_column IN VARCHAR2,
865: p_marker IN OUT NOCOPY BOOLEAN
866: )
867: RETURN rcv_transactions_interface.item_id%TYPE IS
868: x_item_id rcv_transactions_interface.item_id%TYPE;
869: BEGIN
870: p_marker := FALSE;
871:
872: IF ( p_item_description IS NULL

Line 891: p_item_num IN rcv_transactions_interface.item_num%TYPE,

887: RETURN NULL;
888: END get_item_id_from_description;
889: */
890: FUNCTION get_item_id_from_num(
891: p_item_num IN rcv_transactions_interface.item_num%TYPE,
892: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,
893: p_column IN VARCHAR2,
894: p_marker IN OUT NOCOPY BOOLEAN
895: )

Line 892: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,

888: END get_item_id_from_description;
889: */
890: FUNCTION get_item_id_from_num(
891: p_item_num IN rcv_transactions_interface.item_num%TYPE,
892: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,
893: p_column IN VARCHAR2,
894: p_marker IN OUT NOCOPY BOOLEAN
895: )
896: RETURN rcv_transactions_interface.item_id%TYPE IS

Line 896: RETURN rcv_transactions_interface.item_id%TYPE IS

892: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,
893: p_column IN VARCHAR2,
894: p_marker IN OUT NOCOPY BOOLEAN
895: )
896: RETURN rcv_transactions_interface.item_id%TYPE IS
897: x_item_id rcv_transactions_interface.item_id%TYPE;
898: BEGIN
899: p_marker := FALSE;
900:

Line 897: x_item_id rcv_transactions_interface.item_id%TYPE;

893: p_column IN VARCHAR2,
894: p_marker IN OUT NOCOPY BOOLEAN
895: )
896: RETURN rcv_transactions_interface.item_id%TYPE IS
897: x_item_id rcv_transactions_interface.item_id%TYPE;
898: BEGIN
899: p_marker := FALSE;
900:
901: IF ( p_item_num IS NULL

Line 922: p_item_id IN rcv_transactions_interface.item_id%TYPE,

918: RETURN NULL;
919: END get_item_id_from_num;
920:
921: FUNCTION get_item_description_from_id(
922: p_item_id IN rcv_transactions_interface.item_id%TYPE,
923: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,
924: p_column IN VARCHAR2,
925: p_marker IN OUT NOCOPY BOOLEAN
926: )

Line 923: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,

919: END get_item_id_from_num;
920:
921: FUNCTION get_item_description_from_id(
922: p_item_id IN rcv_transactions_interface.item_id%TYPE,
923: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,
924: p_column IN VARCHAR2,
925: p_marker IN OUT NOCOPY BOOLEAN
926: )
927: RETURN rcv_transactions_interface.item_description%TYPE IS

Line 927: RETURN rcv_transactions_interface.item_description%TYPE IS

923: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,
924: p_column IN VARCHAR2,
925: p_marker IN OUT NOCOPY BOOLEAN
926: )
927: RETURN rcv_transactions_interface.item_description%TYPE IS
928: x_item_description rcv_transactions_interface.item_description%TYPE;
929: BEGIN
930: p_marker := FALSE;
931:

Line 928: x_item_description rcv_transactions_interface.item_description%TYPE;

924: p_column IN VARCHAR2,
925: p_marker IN OUT NOCOPY BOOLEAN
926: )
927: RETURN rcv_transactions_interface.item_description%TYPE IS
928: x_item_description rcv_transactions_interface.item_description%TYPE;
929: BEGIN
930: p_marker := FALSE;
931:
932: IF ( p_item_id IS NULL

Line 958: p_item_id IN rcv_transactions_interface.item_id%TYPE,

954: RETURN NULL;
955: END get_item_description_from_id;
956:
957: FUNCTION get_item_num_from_id(
958: p_item_id IN rcv_transactions_interface.item_id%TYPE,
959: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,
960: p_column IN VARCHAR2,
961: p_marker IN OUT NOCOPY BOOLEAN
962: )

Line 959: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,

955: END get_item_description_from_id;
956:
957: FUNCTION get_item_num_from_id(
958: p_item_id IN rcv_transactions_interface.item_id%TYPE,
959: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,
960: p_column IN VARCHAR2,
961: p_marker IN OUT NOCOPY BOOLEAN
962: )
963: RETURN rcv_transactions_interface.item_num%TYPE IS

Line 963: RETURN rcv_transactions_interface.item_num%TYPE IS

959: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,
960: p_column IN VARCHAR2,
961: p_marker IN OUT NOCOPY BOOLEAN
962: )
963: RETURN rcv_transactions_interface.item_num%TYPE IS
964: x_item_num rcv_transactions_interface.item_num%TYPE;
965: BEGIN
966: p_marker := FALSE;
967:

Line 964: x_item_num rcv_transactions_interface.item_num%TYPE;

960: p_column IN VARCHAR2,
961: p_marker IN OUT NOCOPY BOOLEAN
962: )
963: RETURN rcv_transactions_interface.item_num%TYPE IS
964: x_item_num rcv_transactions_interface.item_num%TYPE;
965: BEGIN
966: p_marker := FALSE;
967:
968: IF ( p_item_id IS NULL

Line 989: p_uom_code IN rcv_transactions_interface.uom_code%TYPE,

985: RETURN NULL;
986: END get_item_num_from_id;
987:
988: FUNCTION get_uom_measure_from_code(
989: p_uom_code IN rcv_transactions_interface.uom_code%TYPE,
990: p_column IN VARCHAR2,
991: p_marker IN OUT NOCOPY BOOLEAN
992: )
993: RETURN rcv_transactions_interface.unit_of_measure%TYPE IS

Line 993: RETURN rcv_transactions_interface.unit_of_measure%TYPE IS

989: p_uom_code IN rcv_transactions_interface.uom_code%TYPE,
990: p_column IN VARCHAR2,
991: p_marker IN OUT NOCOPY BOOLEAN
992: )
993: RETURN rcv_transactions_interface.unit_of_measure%TYPE IS
994: x_unit_of_measure rcv_transactions_interface.unit_of_measure%TYPE;
995: BEGIN
996: p_marker := FALSE;
997:

Line 994: x_unit_of_measure rcv_transactions_interface.unit_of_measure%TYPE;

990: p_column IN VARCHAR2,
991: p_marker IN OUT NOCOPY BOOLEAN
992: )
993: RETURN rcv_transactions_interface.unit_of_measure%TYPE IS
994: x_unit_of_measure rcv_transactions_interface.unit_of_measure%TYPE;
995: BEGIN
996: p_marker := FALSE;
997:
998: IF (p_uom_code IS NULL) THEN

Line 1017: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%TYPE,

1013: RETURN NULL;
1014: END get_uom_measure_from_code;
1015:
1016: FUNCTION get_uom_code_from_measure(
1017: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%TYPE,
1018: p_column IN VARCHAR2,
1019: p_marker IN OUT NOCOPY BOOLEAN
1020: )
1021: RETURN rcv_transactions_interface.uom_code%TYPE IS

Line 1021: RETURN rcv_transactions_interface.uom_code%TYPE IS

1017: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%TYPE,
1018: p_column IN VARCHAR2,
1019: p_marker IN OUT NOCOPY BOOLEAN
1020: )
1021: RETURN rcv_transactions_interface.uom_code%TYPE IS
1022: x_uom_code rcv_transactions_interface.uom_code%TYPE;
1023: BEGIN
1024: p_marker := FALSE;
1025:

Line 1022: x_uom_code rcv_transactions_interface.uom_code%TYPE;

1018: p_column IN VARCHAR2,
1019: p_marker IN OUT NOCOPY BOOLEAN
1020: )
1021: RETURN rcv_transactions_interface.uom_code%TYPE IS
1022: x_uom_code rcv_transactions_interface.uom_code%TYPE;
1023: BEGIN
1024: p_marker := FALSE;
1025:
1026: IF (p_unit_of_measure IS NULL) THEN

Line 1046: p_locator IN rcv_transactions_interface.LOCATOR%TYPE,

1042: RETURN NULL;
1043: END get_uom_code_from_measure;
1044:
1045: FUNCTION get_locator_id_from_locator(
1046: p_locator IN rcv_transactions_interface.LOCATOR%TYPE,
1047: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,
1048: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,
1049: p_column IN VARCHAR2,
1050: p_marker IN OUT NOCOPY BOOLEAN

Line 1047: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,

1043: END get_uom_code_from_measure;
1044:
1045: FUNCTION get_locator_id_from_locator(
1046: p_locator IN rcv_transactions_interface.LOCATOR%TYPE,
1047: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,
1048: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,
1049: p_column IN VARCHAR2,
1050: p_marker IN OUT NOCOPY BOOLEAN
1051: )

Line 1048: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,

1044:
1045: FUNCTION get_locator_id_from_locator(
1046: p_locator IN rcv_transactions_interface.LOCATOR%TYPE,
1047: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,
1048: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,
1049: p_column IN VARCHAR2,
1050: p_marker IN OUT NOCOPY BOOLEAN
1051: )
1052: RETURN rcv_transactions_interface.locator_id%TYPE IS

Line 1052: RETURN rcv_transactions_interface.locator_id%TYPE IS

1048: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,
1049: p_column IN VARCHAR2,
1050: p_marker IN OUT NOCOPY BOOLEAN
1051: )
1052: RETURN rcv_transactions_interface.locator_id%TYPE IS
1053: x_locator_id rcv_transactions_interface.locator_id%TYPE;
1054: BEGIN
1055: p_marker := FALSE;
1056:

Line 1053: x_locator_id rcv_transactions_interface.locator_id%TYPE;

1049: p_column IN VARCHAR2,
1050: p_marker IN OUT NOCOPY BOOLEAN
1051: )
1052: RETURN rcv_transactions_interface.locator_id%TYPE IS
1053: x_locator_id rcv_transactions_interface.locator_id%TYPE;
1054: BEGIN
1055: p_marker := FALSE;
1056:
1057: IF ( p_locator IS NULL

Line 1082: p_locator_id IN rcv_transactions_interface.locator_id%TYPE,

1078: RETURN NULL;
1079: END get_locator_id_from_locator;
1080:
1081: FUNCTION get_locator_from_locator_id(
1082: p_locator_id IN rcv_transactions_interface.locator_id%TYPE,
1083: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,
1084: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,
1085: p_column IN VARCHAR2,
1086: p_marker IN OUT NOCOPY BOOLEAN

Line 1083: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,

1079: END get_locator_id_from_locator;
1080:
1081: FUNCTION get_locator_from_locator_id(
1082: p_locator_id IN rcv_transactions_interface.locator_id%TYPE,
1083: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,
1084: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,
1085: p_column IN VARCHAR2,
1086: p_marker IN OUT NOCOPY BOOLEAN
1087: )

Line 1084: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,

1080:
1081: FUNCTION get_locator_from_locator_id(
1082: p_locator_id IN rcv_transactions_interface.locator_id%TYPE,
1083: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,
1084: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,
1085: p_column IN VARCHAR2,
1086: p_marker IN OUT NOCOPY BOOLEAN
1087: )
1088: RETURN rcv_transactions_interface.LOCATOR%TYPE IS

Line 1088: RETURN rcv_transactions_interface.LOCATOR%TYPE IS

1084: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,
1085: p_column IN VARCHAR2,
1086: p_marker IN OUT NOCOPY BOOLEAN
1087: )
1088: RETURN rcv_transactions_interface.LOCATOR%TYPE IS
1089: x_locator rcv_transactions_interface.LOCATOR%TYPE;
1090: BEGIN
1091: p_marker := FALSE;
1092:

Line 1089: x_locator rcv_transactions_interface.LOCATOR%TYPE;

1085: p_column IN VARCHAR2,
1086: p_marker IN OUT NOCOPY BOOLEAN
1087: )
1088: RETURN rcv_transactions_interface.LOCATOR%TYPE IS
1089: x_locator rcv_transactions_interface.LOCATOR%TYPE;
1090: BEGIN
1091: p_marker := FALSE;
1092:
1093: IF ( p_locator_id IS NULL

Line 1118: p_routing_code IN rcv_transactions_interface.routing_code%TYPE,

1114: RETURN NULL;
1115: END get_locator_from_locator_id;
1116:
1117: FUNCTION get_rtng_header_id_from_code(
1118: p_routing_code IN rcv_transactions_interface.routing_code%TYPE,
1119: p_column IN VARCHAR2,
1120: p_marker IN OUT NOCOPY BOOLEAN
1121: )
1122: RETURN rcv_transactions_interface.routing_header_id%TYPE IS

Line 1122: RETURN rcv_transactions_interface.routing_header_id%TYPE IS

1118: p_routing_code IN rcv_transactions_interface.routing_code%TYPE,
1119: p_column IN VARCHAR2,
1120: p_marker IN OUT NOCOPY BOOLEAN
1121: )
1122: RETURN rcv_transactions_interface.routing_header_id%TYPE IS
1123: x_routing_header_id rcv_transactions_interface.routing_header_id%TYPE;
1124: BEGIN
1125: p_marker := FALSE;
1126:

Line 1123: x_routing_header_id rcv_transactions_interface.routing_header_id%TYPE;

1119: p_column IN VARCHAR2,
1120: p_marker IN OUT NOCOPY BOOLEAN
1121: )
1122: RETURN rcv_transactions_interface.routing_header_id%TYPE IS
1123: x_routing_header_id rcv_transactions_interface.routing_header_id%TYPE;
1124: BEGIN
1125: p_marker := FALSE;
1126:
1127: IF (p_routing_code IS NULL) THEN

Line 1146: p_routing_step IN rcv_transactions_interface.routing_step%TYPE,

1142: RETURN NULL;
1143: END get_rtng_header_id_from_code;
1144:
1145: FUNCTION get_rtng_step_id_from_code(
1146: p_routing_step IN rcv_transactions_interface.routing_step%TYPE,
1147: p_column IN VARCHAR2,
1148: p_marker IN OUT NOCOPY BOOLEAN
1149: )
1150: RETURN rcv_transactions_interface.routing_step_id%TYPE IS

Line 1150: RETURN rcv_transactions_interface.routing_step_id%TYPE IS

1146: p_routing_step IN rcv_transactions_interface.routing_step%TYPE,
1147: p_column IN VARCHAR2,
1148: p_marker IN OUT NOCOPY BOOLEAN
1149: )
1150: RETURN rcv_transactions_interface.routing_step_id%TYPE IS
1151: x_routing_step_id rcv_transactions_interface.routing_step_id%TYPE;
1152: BEGIN
1153: p_marker := FALSE;
1154:

Line 1151: x_routing_step_id rcv_transactions_interface.routing_step_id%TYPE;

1147: p_column IN VARCHAR2,
1148: p_marker IN OUT NOCOPY BOOLEAN
1149: )
1150: RETURN rcv_transactions_interface.routing_step_id%TYPE IS
1151: x_routing_step_id rcv_transactions_interface.routing_step_id%TYPE;
1152: BEGIN
1153: p_marker := FALSE;
1154:
1155: IF (p_routing_step IS NULL) THEN

Line 1174: p_wip_entity_name IN rcv_transactions_interface.wip_entity_name%TYPE,

1170: RETURN NULL;
1171: END get_rtng_step_id_from_code;
1172:
1173: FUNCTION get_wip_entity_id_from_name(
1174: p_wip_entity_name IN rcv_transactions_interface.wip_entity_name%TYPE,
1175: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,
1176: p_column IN VARCHAR2,
1177: p_marker IN OUT NOCOPY BOOLEAN
1178: )

Line 1175: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,

1171: END get_rtng_step_id_from_code;
1172:
1173: FUNCTION get_wip_entity_id_from_name(
1174: p_wip_entity_name IN rcv_transactions_interface.wip_entity_name%TYPE,
1175: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,
1176: p_column IN VARCHAR2,
1177: p_marker IN OUT NOCOPY BOOLEAN
1178: )
1179: RETURN rcv_transactions_interface.wip_entity_id%TYPE IS

Line 1179: RETURN rcv_transactions_interface.wip_entity_id%TYPE IS

1175: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,
1176: p_column IN VARCHAR2,
1177: p_marker IN OUT NOCOPY BOOLEAN
1178: )
1179: RETURN rcv_transactions_interface.wip_entity_id%TYPE IS
1180: x_wip_entity_id rcv_transactions_interface.wip_entity_id%TYPE;
1181: BEGIN
1182: p_marker := FALSE;
1183:

Line 1180: x_wip_entity_id rcv_transactions_interface.wip_entity_id%TYPE;

1176: p_column IN VARCHAR2,
1177: p_marker IN OUT NOCOPY BOOLEAN
1178: )
1179: RETURN rcv_transactions_interface.wip_entity_id%TYPE IS
1180: x_wip_entity_id rcv_transactions_interface.wip_entity_id%TYPE;
1181: BEGIN
1182: p_marker := FALSE;
1183:
1184: IF ( p_wip_entity_name IS NULL

Line 1205: p_wip_entity_id IN rcv_transactions_interface.wip_entity_id%TYPE,

1201: RETURN NULL;
1202: END get_wip_entity_id_from_name;
1203:
1204: FUNCTION get_wip_entity_name_from_id(
1205: p_wip_entity_id IN rcv_transactions_interface.wip_entity_id%TYPE,
1206: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,
1207: p_column IN VARCHAR2,
1208: p_marker IN OUT NOCOPY BOOLEAN
1209: )

Line 1206: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,

1202: END get_wip_entity_id_from_name;
1203:
1204: FUNCTION get_wip_entity_name_from_id(
1205: p_wip_entity_id IN rcv_transactions_interface.wip_entity_id%TYPE,
1206: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,
1207: p_column IN VARCHAR2,
1208: p_marker IN OUT NOCOPY BOOLEAN
1209: )
1210: RETURN rcv_transactions_interface.wip_entity_name%TYPE IS

Line 1210: RETURN rcv_transactions_interface.wip_entity_name%TYPE IS

1206: p_org_id IN rcv_transactions_interface.to_organization_id%TYPE,
1207: p_column IN VARCHAR2,
1208: p_marker IN OUT NOCOPY BOOLEAN
1209: )
1210: RETURN rcv_transactions_interface.wip_entity_name%TYPE IS
1211: x_wip_entity_name rcv_transactions_interface.wip_entity_name%TYPE;
1212: BEGIN
1213: p_marker := FALSE;
1214:

Line 1211: x_wip_entity_name rcv_transactions_interface.wip_entity_name%TYPE;

1207: p_column IN VARCHAR2,
1208: p_marker IN OUT NOCOPY BOOLEAN
1209: )
1210: RETURN rcv_transactions_interface.wip_entity_name%TYPE IS
1211: x_wip_entity_name rcv_transactions_interface.wip_entity_name%TYPE;
1212: BEGIN
1213: p_marker := FALSE;
1214:
1215: IF ( p_wip_entity_id IS NULL

Line 1609: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

1605: END IF;
1606: END check_rhi_consistency;
1607:
1608: PROCEDURE default_rti_from_code(
1609: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
1610: ) IS
1611: x_dummy_mkr BOOLEAN;
1612: BEGIN
1613: IF (rti.customer_id IS NULL) THEN

Line 2182: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

2178: /* Not processing TRANSFER_LICENSE_PLATE_NUMBER or WIP_LINE_CODE*/
2179: END default_rti_from_code;
2180:
2181: PROCEDURE check_rti_consistency(
2182: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
2183: ) IS
2184: x_dummy_mkr BOOLEAN;
2185: BEGIN
2186: IF (g_rti_ou_mkr = TRUE) THEN

Line 2793: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

2789: END IF;
2790: END default_rhi_from_rsh;
2791:
2792: PROCEDURE default_rti_from_rhi(
2793: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
2794: ) IS
2795: rhi rcv_headers_interface%ROWTYPE;
2796: BEGIN
2797: /* If this row does not have a header_interface_id it is possible that the

Line 3149: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

3145: END IF;
3146: END default_rti_from_rhi;
3147:
3148: PROCEDURE default_rti_from_rti(
3149: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
3150: ) IS
3151: prti rcv_transactions_interface%ROWTYPE;
3152: BEGIN
3153: IF (rti.parent_interface_txn_id IS NOT NULL) THEN

Line 3151: prti rcv_transactions_interface%ROWTYPE;

3147:
3148: PROCEDURE default_rti_from_rti(
3149: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
3150: ) IS
3151: prti rcv_transactions_interface%ROWTYPE;
3152: BEGIN
3153: IF (rti.parent_interface_txn_id IS NOT NULL) THEN
3154: prti := rcv_table_functions.get_rti_row_from_id(rti.parent_interface_txn_id);
3155: END IF;

Line 4352: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

4348: * 5299177 */
4349: END default_rti_from_rti;
4350:
4351: PROCEDURE default_rti_from_rt(
4352: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
4353: ) IS
4354: rt rcv_transactions%ROWTYPE;
4355: BEGIN
4356: IF (rti.parent_transaction_id IS NOT NULL) THEN

Line 4933: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

4929: * 5299177 */
4930: END default_rti_from_rt;
4931:
4932: PROCEDURE default_rti_from_rsl(
4933: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
4934: ) IS
4935: rsl rcv_shipment_lines%ROWTYPE;
4936: /** Bug: 5502427
4937: * For Internal Orders, oe_order_line_id is getting stamped in RTI

Line 5386: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

5382: END IF;*/
5383: END default_rti_from_rsl;
5384:
5385: PROCEDURE default_rti_from_rsh(
5386: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
5387: ) IS
5388: rsh rcv_shipment_headers%ROWTYPE;
5389: BEGIN
5390: IF (rti.shipment_header_id IS NOT NULL) THEN

Line 5610: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

5606: END IF;
5607: END default_rti_from_rsh;
5608:
5609: PROCEDURE default_rti_from_pod(
5610: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
5611: ) IS
5612: pod po_distributions_all%ROWTYPE;
5613: x_quantity NUMBER;
5614: BEGIN

Line 5907: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

5903: * 5299177 */
5904: END default_rti_from_pod;
5905:
5906: PROCEDURE default_rti_from_pll(
5907: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
5908: ) IS
5909: pll po_line_locations_all%ROWTYPE;
5910: x_quantity NUMBER;
5911: BEGIN

Line 6198: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

6194: */
6195: END default_rti_from_pll;
6196:
6197: PROCEDURE default_rti_from_pol(
6198: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
6199: ) IS
6200: pol po_lines_all%ROWTYPE;
6201: BEGIN
6202: asn_debug.put_line('Enter default_rti_from_pol');

Line 6452: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

6448: asn_debug.put_line('Leave default_rti_from_pol');
6449: END default_rti_from_pol;
6450:
6451: PROCEDURE default_rti_from_poh(
6452: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
6453: ) IS
6454: poh po_headers_all%ROWTYPE;
6455: BEGIN
6456: IF (rti.po_header_id IS NOT NULL) THEN

Line 6609: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

6605: END IF;
6606: END default_rti_from_poh;
6607:
6608: PROCEDURE default_rti_from_oel(
6609: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
6610: ) IS
6611: oel oe_order_lines_all%ROWTYPE;
6612: BEGIN
6613: IF (rti.oe_order_line_id IS NOT NULL) THEN

Line 6869: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

6865: * 5299177 */
6866: END default_rti_from_oel;
6867:
6868: PROCEDURE default_rti_from_oeh(
6869: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
6870: ) IS
6871: oeh oe_order_headers_all%ROWTYPE;
6872: BEGIN
6873: IF (rti.oe_order_header_id IS NOT NULL) THEN

Line 6968: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

6964: /************************************/
6965: /* SECTION 5: default row framework */
6966: /************************************/
6967: PROCEDURE create_rhi_from_rti(
6968: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
6969: ) IS
6970: x_receipt_num rcv_headers_interface.receipt_num%TYPE;
6971: BEGIN
6972: IF (rti.header_interface_id IS NOT NULL) THEN

Line 7132: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

7128: lot control code and serial control code of the item in the
7129: given inventory org.
7130: */
7131: PROCEDURE default_lot_serial_control(
7132: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
7133: )IS
7134: BEGIN
7135: /*
7136: NOTE: For one time item the item_id would be null and hence there is

Line 7193: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

7189: rcv_error_pkg.log_interface_error('INTERFACE_TRANSACTION_ID');
7190: END default_header;
7191:
7192: PROCEDURE default_transaction(
7193: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
7194: ) IS
7195: x_dummy_mkr BOOLEAN;
7196: x_temp_subinv rcv_transactions_interface.subinventory%TYPE;
7197: x_temp_primary_uom rcv_transactions_interface.primary_unit_of_measure%TYPE;

Line 7196: x_temp_subinv rcv_transactions_interface.subinventory%TYPE;

7192: PROCEDURE default_transaction(
7193: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
7194: ) IS
7195: x_dummy_mkr BOOLEAN;
7196: x_temp_subinv rcv_transactions_interface.subinventory%TYPE;
7197: x_temp_primary_uom rcv_transactions_interface.primary_unit_of_measure%TYPE;
7198: x_subinv_starts_null BOOLEAN;
7199: BEGIN
7200: elapsed_time('BEGIN default_transaction');

Line 7197: x_temp_primary_uom rcv_transactions_interface.primary_unit_of_measure%TYPE;

7193: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
7194: ) IS
7195: x_dummy_mkr BOOLEAN;
7196: x_temp_subinv rcv_transactions_interface.subinventory%TYPE;
7197: x_temp_primary_uom rcv_transactions_interface.primary_unit_of_measure%TYPE;
7198: x_subinv_starts_null BOOLEAN;
7199: BEGIN
7200: elapsed_time('BEGIN default_transaction');
7201: asn_debug.put_line('rti.interface_transaction_id = ' || rti.interface_transaction_id);

Line 7764: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

7760: rcv_error_pkg.log_interface_error('INTERFACE_TRANSACTION_ID');
7761: END default_transaction;
7762:
7763: PROCEDURE default_from_parent(
7764: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
7765: ) IS
7766: BEGIN
7767: default_rti_from_rti(rti);
7768: END default_from_parent;