DBA Data[Home] [Help]

APPS.PO_VAL_SHIPMENTS2 dependencies on PO_VALIDATION_RESULTS_TYPE

Line 46: x_results IN OUT NOCOPY po_validation_results_type,

42: PROCEDURE need_by_date(
43: p_id_tbl IN po_tbl_number,
44: p_purchase_basis_tbl IN po_tbl_varchar30,
45: p_need_by_date_tbl IN po_tbl_date,
46: x_results IN OUT NOCOPY po_validation_results_type,
47: x_result_type OUT NOCOPY VARCHAR2)
48: IS
49: d_mod CONSTANT VARCHAR2(100) := d_need_by_date;
50: BEGIN

Line 52: x_results := po_validation_results_type.new_instance();

48: IS
49: d_mod CONSTANT VARCHAR2(100) := d_need_by_date;
50: BEGIN
51: IF (x_results IS NULL) THEN
52: x_results := po_validation_results_type.new_instance();
53: END IF;
54:
55: x_result_type := po_validations.c_result_type_success;
56:

Line 97: x_results IN OUT NOCOPY po_validation_results_type,

93: PROCEDURE promised_date(
94: p_id_tbl IN po_tbl_number,
95: p_purchase_basis_tbl IN po_tbl_varchar30,
96: p_promised_date_tbl IN po_tbl_date,
97: x_results IN OUT NOCOPY po_validation_results_type,
98: x_result_type OUT NOCOPY VARCHAR2)
99: IS
100: d_mod CONSTANT VARCHAR2(100) := d_promised_date;
101: BEGIN

Line 103: x_results := po_validation_results_type.new_instance();

99: IS
100: d_mod CONSTANT VARCHAR2(100) := d_promised_date;
101: BEGIN
102: IF (x_results IS NULL) THEN
103: x_results := po_validation_results_type.new_instance();
104: END IF;
105:
106: x_result_type := po_validations.c_result_type_success;
107:

Line 148: x_results IN OUT NOCOPY po_validation_results_type,

144: PROCEDURE shipment_type(
145: p_id_tbl IN po_tbl_number,
146: p_shipment_type_tbl IN po_tbl_varchar30,
147: p_doc_type IN VARCHAR2,
148: x_results IN OUT NOCOPY po_validation_results_type,
149: x_result_type OUT NOCOPY VARCHAR2)
150: IS
151: d_mod CONSTANT VARCHAR2(100) := d_shipment_type;
152: BEGIN

Line 154: x_results := po_validation_results_type.new_instance();

150: IS
151: d_mod CONSTANT VARCHAR2(100) := d_shipment_type;
152: BEGIN
153: IF (x_results IS NULL) THEN
154: x_results := po_validation_results_type.new_instance();
155: END IF;
156:
157: x_result_type := po_validations.c_result_type_success;
158:

Line 214: x_results IN OUT NOCOPY po_validation_results_type,

210: p_po_line_id_tbl IN po_tbl_number,
211: p_draft_id_tbl IN PO_TBL_NUMBER, -- bug 4642348
212: p_doc_type IN VARCHAR2, -- bug 4642348
213: x_result_set_id IN OUT NOCOPY NUMBER,
214: x_results IN OUT NOCOPY po_validation_results_type,
215: x_result_type OUT NOCOPY VARCHAR2)
216: IS
217: d_mod CONSTANT VARCHAR2(100) := d_shipment_num;
218: BEGIN

Line 224: x_results := po_validation_results_type.new_instance();

220: x_result_set_id := po_validations.next_result_set_id();
221: END IF;
222:
223: IF (x_results IS NULL) THEN
224: x_results := po_validation_results_type.new_instance();
225: END IF;
226:
227: IF po_log.d_proc THEN
228: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 338: x_results IN OUT NOCOPY po_validation_results_type,

334: PROCEDURE quantity(
335: p_id_tbl IN po_tbl_number,
336: p_quantity_tbl IN po_tbl_number,
337: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
338: x_results IN OUT NOCOPY po_validation_results_type,
339: x_result_type OUT NOCOPY VARCHAR2)
340: IS
341: d_mod CONSTANT VARCHAR2(100) := d_quantity;
342: BEGIN

Line 344: x_results := po_validation_results_type.new_instance();

340: IS
341: d_mod CONSTANT VARCHAR2(100) := d_quantity;
342: BEGIN
343: IF (x_results IS NULL) THEN
344: x_results := po_validation_results_type.new_instance();
345: END IF;
346:
347: x_result_type := po_validations.c_result_type_success;
348:

Line 406: x_results IN OUT NOCOPY po_validation_results_type,

402: PROCEDURE price_override(
403: p_id_tbl IN po_tbl_number,
404: p_price_override_tbl IN po_tbl_number,
405: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
406: x_results IN OUT NOCOPY po_validation_results_type,
407: x_result_type OUT NOCOPY VARCHAR2)
408: IS
409: d_mod CONSTANT VARCHAR2(100) := d_price_override;
410: BEGIN

Line 412: x_results := po_validation_results_type.new_instance();

408: IS
409: d_mod CONSTANT VARCHAR2(100) := d_price_override;
410: BEGIN
411: IF (x_results IS NULL) THEN
412: x_results := po_validation_results_type.new_instance();
413: END IF;
414:
415: x_result_type := po_validations.c_result_type_success;
416:

Line 473: x_results IN OUT NOCOPY po_validation_results_type,

469: p_id_tbl IN po_tbl_number,
470: p_price_discount_tbl IN po_tbl_number,
471: p_price_override_tbl IN po_tbl_number,
472: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
473: x_results IN OUT NOCOPY po_validation_results_type,
474: x_result_type OUT NOCOPY VARCHAR2)
475: IS
476: d_mod CONSTANT VARCHAR2(100) := d_price_discount;
477: BEGIN

Line 479: x_results := po_validation_results_type.new_instance();

475: IS
476: d_mod CONSTANT VARCHAR2(100) := d_price_discount;
477: BEGIN
478: IF (x_results IS NULL) THEN
479: x_results := po_validation_results_type.new_instance();
480: END IF;
481:
482: x_result_type := po_validations.c_result_type_success;
483:

Line 748: x_results IN OUT NOCOPY po_validation_results_type,

744: p_to_date_tbl IN po_tbl_date,
745: p_quantity_tbl IN po_tbl_number,
746: p_ship_to_org_id_tbl IN po_tbl_number,
747: p_ship_to_location_id_tbl IN po_tbl_number,
748: x_results IN OUT NOCOPY po_validation_results_type,
749: x_result_type OUT NOCOPY VARCHAR2)
750: IS
751: d_mod CONSTANT VARCHAR2(100) := d_price_break_attributes;
752: BEGIN

Line 754: x_results := po_validation_results_type.new_instance();

750: IS
751: d_mod CONSTANT VARCHAR2(100) := d_price_break_attributes;
752: BEGIN
753: IF (x_results IS NULL) THEN
754: x_results := po_validation_results_type.new_instance();
755: END IF;
756:
757: x_result_type := po_validations.c_result_type_success;
758:

Line 808: x_results IN OUT NOCOPY po_validation_results_type,

804: p_from_date_tbl IN po_tbl_date,
805: p_header_start_date_tbl IN po_tbl_date,
806: p_header_end_date_tbl IN po_tbl_date,
807: p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30, -- bug5016163
808: x_results IN OUT NOCOPY po_validation_results_type,
809: x_result_type OUT NOCOPY VARCHAR2)
810: IS
811: d_mod CONSTANT VARCHAR2(100) := d_effective_dates;
812: BEGIN

Line 814: x_results := po_validation_results_type.new_instance();

810: IS
811: d_mod CONSTANT VARCHAR2(100) := d_effective_dates;
812: BEGIN
813: IF (x_results IS NULL) THEN
814: x_results := po_validation_results_type.new_instance();
815: END IF;
816:
817: x_result_type := po_validations.c_result_type_success;
818:

Line 1058: x_results IN OUT NOCOPY po_validation_results_type,

1054: PROCEDURE enforce_ship_to_loc_code(
1055: p_id_tbl IN po_tbl_number,
1056: p_enforce_ship_to_loc_code_tbl IN po_tbl_varchar30,
1057: p_shipment_type_tbl IN po_tbl_varchar30,
1058: x_results IN OUT NOCOPY po_validation_results_type,
1059: x_result_type OUT NOCOPY VARCHAR2)
1060: IS
1061: d_mod CONSTANT VARCHAR2(100) := d_enforce_ship_to_loc_code;
1062: BEGIN

Line 1064: x_results := po_validation_results_type.new_instance();

1060: IS
1061: d_mod CONSTANT VARCHAR2(100) := d_enforce_ship_to_loc_code;
1062: BEGIN
1063: IF (x_results IS NULL) THEN
1064: x_results := po_validation_results_type.new_instance();
1065: END IF;
1066:
1067: x_result_type := po_validations.c_result_type_success;
1068:

Line 1113: x_results IN OUT NOCOPY po_validation_results_type,

1109: PROCEDURE allow_sub_receipts_flag(
1110: p_id_tbl IN po_tbl_number,
1111: p_shipment_type_tbl IN po_tbl_varchar30,
1112: p_allow_sub_receipts_flag_tbl IN po_tbl_varchar1,
1113: x_results IN OUT NOCOPY po_validation_results_type,
1114: x_result_type OUT NOCOPY VARCHAR2)
1115: IS
1116: d_mod CONSTANT VARCHAR2(100) := d_allow_sub_receipts_flag;
1117: BEGIN

Line 1119: x_results := po_validation_results_type.new_instance();

1115: IS
1116: d_mod CONSTANT VARCHAR2(100) := d_allow_sub_receipts_flag;
1117: BEGIN
1118: IF (x_results IS NULL) THEN
1119: x_results := po_validation_results_type.new_instance();
1120: END IF;
1121:
1122: x_result_type := po_validations.c_result_type_success;
1123:

Line 1166: x_results IN OUT NOCOPY po_validation_results_type,

1162: PROCEDURE days_early_receipt_allowed(
1163: p_id_tbl IN po_tbl_number,
1164: p_shipment_type_tbl IN po_tbl_varchar30,
1165: p_days_early_rcpt_allowed_tbl IN po_tbl_number,
1166: x_results IN OUT NOCOPY po_validation_results_type,
1167: x_result_type OUT NOCOPY VARCHAR2)
1168: IS
1169: d_mod CONSTANT VARCHAR2(100) := d_days_early_receipt_allowed;
1170: BEGIN

Line 1172: x_results := po_validation_results_type.new_instance();

1168: IS
1169: d_mod CONSTANT VARCHAR2(100) := d_days_early_receipt_allowed;
1170: BEGIN
1171: IF (x_results IS NULL) THEN
1172: x_results := po_validation_results_type.new_instance();
1173: END IF;
1174:
1175: x_result_type := po_validations.c_result_type_success;
1176:

Line 1220: x_results IN OUT NOCOPY po_validation_results_type,

1216: PROCEDURE receipt_days_exception_code(
1217: p_id_tbl IN po_tbl_number,
1218: p_shipment_type_tbl IN po_tbl_varchar30,
1219: p_rcpt_days_exception_code_tbl IN po_tbl_varchar30,
1220: x_results IN OUT NOCOPY po_validation_results_type,
1221: x_result_type OUT NOCOPY VARCHAR2)
1222: IS
1223: d_mod CONSTANT VARCHAR2(100) := d_receipt_days_exception_code;
1224: BEGIN

Line 1226: x_results := po_validation_results_type.new_instance();

1222: IS
1223: d_mod CONSTANT VARCHAR2(100) := d_receipt_days_exception_code;
1224: BEGIN
1225: IF (x_results IS NULL) THEN
1226: x_results := po_validation_results_type.new_instance();
1227: END IF;
1228:
1229: x_result_type := po_validations.c_result_type_success;
1230:

Line 1274: x_results IN OUT NOCOPY po_validation_results_type,

1270: PROCEDURE invoice_close_tolerance(
1271: p_id_tbl IN po_tbl_number,
1272: p_shipment_type_tbl IN po_tbl_varchar30,
1273: p_invoice_close_tolerance_tbl IN po_tbl_number,
1274: x_results IN OUT NOCOPY po_validation_results_type,
1275: x_result_type OUT NOCOPY VARCHAR2)
1276: IS
1277: d_mod CONSTANT VARCHAR2(100) := d_invoice_close_tolerance;
1278: BEGIN

Line 1280: x_results := po_validation_results_type.new_instance();

1276: IS
1277: d_mod CONSTANT VARCHAR2(100) := d_invoice_close_tolerance;
1278: BEGIN
1279: IF (x_results IS NULL) THEN
1280: x_results := po_validation_results_type.new_instance();
1281: END IF;
1282:
1283: x_result_type := po_validations.c_result_type_success;
1284:

Line 1328: x_results IN OUT NOCOPY po_validation_results_type,

1324: PROCEDURE receive_close_tolerance(
1325: p_id_tbl IN po_tbl_number,
1326: p_shipment_type_tbl IN po_tbl_varchar30,
1327: p_receive_close_tolerance_tbl IN po_tbl_number,
1328: x_results IN OUT NOCOPY po_validation_results_type,
1329: x_result_type OUT NOCOPY VARCHAR2)
1330: IS
1331: d_mod CONSTANT VARCHAR2(100) := d_receive_close_tolerance;
1332: BEGIN

Line 1334: x_results := po_validation_results_type.new_instance();

1330: IS
1331: d_mod CONSTANT VARCHAR2(100) := d_receive_close_tolerance;
1332: BEGIN
1333: IF (x_results IS NULL) THEN
1334: x_results := po_validation_results_type.new_instance();
1335: END IF;
1336:
1337: x_result_type := po_validations.c_result_type_success;
1338:

Line 1451: x_results IN OUT NOCOPY po_validation_results_type,

1447: -------------------------------------------------------------------------
1448: PROCEDURE accrue_on_receipt_flag(
1449: p_id_tbl IN po_tbl_number,
1450: p_accrue_on_receipt_flag_tbl IN po_tbl_varchar1,
1451: x_results IN OUT NOCOPY po_validation_results_type,
1452: x_result_type OUT NOCOPY VARCHAR2)
1453: IS
1454: d_mod CONSTANT VARCHAR2(100) := d_accrue_on_receipt_flag;
1455: BEGIN

Line 1457: x_results := po_validation_results_type.new_instance();

1453: IS
1454: d_mod CONSTANT VARCHAR2(100) := d_accrue_on_receipt_flag;
1455: BEGIN
1456: IF (x_results IS NULL) THEN
1457: x_results := po_validation_results_type.new_instance();
1458: END IF;
1459:
1460: x_result_type := po_validations.c_result_type_success;
1461:

Line 1919: x_results IN OUT NOCOPY po_validation_results_type,

1915: -------------------------------------------------------------------------
1916: PROCEDURE price_break(
1917: p_id_tbl IN po_tbl_number,
1918: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1919: x_results IN OUT NOCOPY po_validation_results_type,
1920: x_result_type OUT NOCOPY VARCHAR2)
1921: IS
1922: d_mod CONSTANT VARCHAR2(100) := d_price_break;
1923: BEGIN

Line 1925: x_results := po_validation_results_type.new_instance();

1921: IS
1922: d_mod CONSTANT VARCHAR2(100) := d_price_break;
1923: BEGIN
1924: IF (x_results IS NULL) THEN
1925: x_results := po_validation_results_type.new_instance();
1926: END IF;
1927:
1928: x_result_type := po_validations.c_result_type_success;
1929: