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

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 2791: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

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

Line 3141: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

3137: END IF;
3138: END default_rti_from_rhi;
3139:
3140: PROCEDURE default_rti_from_rti(
3141: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
3142: ) IS
3143: prti rcv_transactions_interface%ROWTYPE;
3144: BEGIN
3145: IF (rti.parent_interface_txn_id IS NOT NULL) THEN

Line 3143: prti rcv_transactions_interface%ROWTYPE;

3139:
3140: PROCEDURE default_rti_from_rti(
3141: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
3142: ) IS
3143: prti rcv_transactions_interface%ROWTYPE;
3144: BEGIN
3145: IF (rti.parent_interface_txn_id IS NOT NULL) THEN
3146: prti := rcv_table_functions.get_rti_row_from_id(rti.parent_interface_txn_id);
3147: END IF;

Line 4344: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

4340: * 5299177 */
4341: END default_rti_from_rti;
4342:
4343: PROCEDURE default_rti_from_rt(
4344: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
4345: ) IS
4346: rt rcv_transactions%ROWTYPE;
4347: BEGIN
4348: IF (rti.parent_transaction_id IS NOT NULL) THEN

Line 4346: rt rcv_transactions%ROWTYPE;

4342:
4343: PROCEDURE default_rti_from_rt(
4344: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
4345: ) IS
4346: rt rcv_transactions%ROWTYPE;
4347: BEGIN
4348: IF (rti.parent_transaction_id IS NOT NULL) THEN
4349: rt := rcv_table_functions.get_rt_row_from_id(rti.parent_transaction_id);
4350: END IF;

Line 4905: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

4901: * 5299177 */
4902: END default_rti_from_rt;
4903:
4904: PROCEDURE default_rti_from_rsl(
4905: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
4906: ) IS
4907: rsl rcv_shipment_lines%ROWTYPE;
4908: /** Bug: 5502427
4909: * For Internal Orders, oe_order_line_id is getting stamped in RTI

Line 5358: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

5354: END IF;*/
5355: END default_rti_from_rsl;
5356:
5357: PROCEDURE default_rti_from_rsh(
5358: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
5359: ) IS
5360: rsh rcv_shipment_headers%ROWTYPE;
5361: BEGIN
5362: IF (rti.shipment_header_id IS NOT NULL) THEN

Line 5579: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

5575: END IF;
5576: END default_rti_from_rsh;
5577:
5578: PROCEDURE default_rti_from_pod(
5579: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
5580: ) IS
5581: pod po_distributions_all%ROWTYPE;
5582: x_quantity NUMBER;
5583: BEGIN

Line 5873: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

5869: * 5299177 */
5870: END default_rti_from_pod;
5871:
5872: PROCEDURE default_rti_from_pll(
5873: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
5874: ) IS
5875: pll po_line_locations_all%ROWTYPE;
5876: x_quantity NUMBER;
5877: BEGIN

Line 6164: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

6160: */
6161: END default_rti_from_pll;
6162:
6163: PROCEDURE default_rti_from_pol(
6164: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
6165: ) IS
6166: pol po_lines_all%ROWTYPE;
6167: BEGIN
6168: asn_debug.put_line('Enter default_rti_from_pol');

Line 6418: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

6414: asn_debug.put_line('Leave default_rti_from_pol');
6415: END default_rti_from_pol;
6416:
6417: PROCEDURE default_rti_from_poh(
6418: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
6419: ) IS
6420: poh po_headers_all%ROWTYPE;
6421: BEGIN
6422: IF (rti.po_header_id IS NOT NULL) THEN

Line 6571: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

6567: -- END IF;
6568: END default_rti_from_poh;
6569:
6570: PROCEDURE default_rti_from_oel(
6571: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
6572: ) IS
6573: oel oe_order_lines_all%ROWTYPE;
6574: BEGIN
6575: IF (rti.oe_order_line_id IS NOT NULL) THEN

Line 6831: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

6827: * 5299177 */
6828: END default_rti_from_oel;
6829:
6830: PROCEDURE default_rti_from_oeh(
6831: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
6832: ) IS
6833: oeh oe_order_headers_all%ROWTYPE;
6834: BEGIN
6835: IF (rti.oe_order_header_id IS NOT NULL) THEN

Line 6930: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

6926: /************************************/
6927: /* SECTION 5: default row framework */
6928: /************************************/
6929: PROCEDURE create_rhi_from_rti(
6930: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
6931: ) IS
6932: x_receipt_num rcv_headers_interface.receipt_num%TYPE;
6933: BEGIN
6934: IF (rti.header_interface_id IS NOT NULL) THEN

Line 7094: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

7090: lot control code and serial control code of the item in the
7091: given inventory org.
7092: */
7093: PROCEDURE default_lot_serial_control(
7094: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
7095: )IS
7096: BEGIN
7097: /*
7098: NOTE: For one time item the item_id would be null and hence there is

Line 7155: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

7151: rcv_error_pkg.log_interface_error('INTERFACE_TRANSACTION_ID');
7152: END default_header;
7153:
7154: PROCEDURE default_transaction(
7155: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
7156: ) IS
7157: x_dummy_mkr BOOLEAN;
7158: x_temp_subinv rcv_transactions_interface.subinventory%TYPE;
7159: x_temp_primary_uom rcv_transactions_interface.primary_unit_of_measure%TYPE;

Line 7158: x_temp_subinv rcv_transactions_interface.subinventory%TYPE;

7154: PROCEDURE default_transaction(
7155: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
7156: ) IS
7157: x_dummy_mkr BOOLEAN;
7158: x_temp_subinv rcv_transactions_interface.subinventory%TYPE;
7159: x_temp_primary_uom rcv_transactions_interface.primary_unit_of_measure%TYPE;
7160: x_subinv_starts_null BOOLEAN;
7161: BEGIN
7162: elapsed_time('BEGIN default_transaction');

Line 7159: x_temp_primary_uom rcv_transactions_interface.primary_unit_of_measure%TYPE;

7155: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
7156: ) IS
7157: x_dummy_mkr BOOLEAN;
7158: x_temp_subinv rcv_transactions_interface.subinventory%TYPE;
7159: x_temp_primary_uom rcv_transactions_interface.primary_unit_of_measure%TYPE;
7160: x_subinv_starts_null BOOLEAN;
7161: BEGIN
7162: elapsed_time('BEGIN default_transaction');
7163: asn_debug.put_line('rti.interface_transaction_id = ' || rti.interface_transaction_id);

Line 7717: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

7713: rcv_error_pkg.log_interface_error('INTERFACE_TRANSACTION_ID');
7714: END default_transaction;
7715:
7716: PROCEDURE default_from_parent(
7717: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
7718: ) IS
7719: BEGIN
7720: default_rti_from_rti(rti);
7721: END default_from_parent;