DBA Data[Home] [Help]

APPS.PO_VAL_DISTRIBUTIONS dependencies on PO_VALIDATION_RESULTS_TYPE

Line 157: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

153: -----------------------------------------------------------------------------
154: PROCEDURE dist_num_gt_zero(
155: p_dist_id_tbl IN PO_TBL_NUMBER
156: , p_dist_num_tbl IN PO_TBL_NUMBER
157: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
158: , x_result_type OUT NOCOPY VARCHAR2
159: )
160: IS
161: BEGIN

Line 187: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

183: p_dist_id_tbl IN PO_TBL_NUMBER
184: , p_qty_ordered_tbl IN PO_TBL_NUMBER
185: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
186: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
187: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
188: , x_result_type OUT NOCOPY VARCHAR2
189: , p_header_id_tbl IN PO_TBL_NUMBER --
190: )
191: IS

Line 340: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

336: p_dist_id_tbl IN PO_TBL_NUMBER
337: , p_amt_ordered_tbl IN PO_TBL_NUMBER
338: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
339: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
340: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
341: , x_result_type OUT NOCOPY VARCHAR2
342: , p_header_id_tbl IN PO_TBL_NUMBER --
343: )
344: IS

Line 499: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

495: , p_item_id_tbl IN PO_TBL_NUMBER
496: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
497: -- Bug# 4338241: Checking if it is inventory and PJM is installed
498: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30
499: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
500: , x_result_type OUT NOCOPY VARCHAR2
501: )
502: IS
503: d_mod CONSTANT VARCHAR2(100) := D_pjm_unit_number_effective;

Line 518: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

514: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
515: END IF;
516:
517: IF (x_results IS NULL) THEN
518: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
519: END IF;
520:
521: l_results_count := x_results.result_type.COUNT;
522:

Line 584: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

580: , p_wip_line_id_tbl IN PO_TBL_NUMBER
581: , p_wip_operation_seq_num_tbl IN PO_TBL_NUMBER
582: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30
583: , p_wip_resource_seq_num_tbl IN PO_TBL_NUMBER
584: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
585: , x_result_type OUT NOCOPY VARCHAR2
586: )
587: IS
588: d_mod CONSTANT VARCHAR2(100) := D_oop_enter_all_fields;

Line 606: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

602: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
603: END IF;
604:
605: IF (x_results IS NULL) THEN
606: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
607: END IF;
608:
609: l_results_count := x_results.result_type.COUNT;
610:

Line 704: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

700: PROCEDURE unencum_amt_le_amt_to_encum(
701: p_dist_id_tbl IN PO_TBL_NUMBER
702: , p_amount_to_encumber_tbl IN PO_TBL_NUMBER
703: , p_unencumbered_amount_tbl IN PO_TBL_NUMBER
704: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
705: , x_result_type OUT NOCOPY VARCHAR2
706: )
707: IS
708: BEGIN

Line 731: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

727: -----------------------------------------------------------------------------
728: PROCEDURE amount_to_encumber_ge_zero(
729: p_dist_id_tbl IN PO_TBL_NUMBER
730: , p_amount_to_encumber_tbl IN PO_TBL_NUMBER
731: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
732: , x_result_type OUT NOCOPY VARCHAR2
733: )
734: IS
735: BEGIN

Line 759: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

755: -------------------------------------------------------------------------------
756: PROCEDURE budget_account_id_not_null(
757: p_dist_id_tbl IN PO_TBL_NUMBER
758: , p_budget_account_id_tbl IN PO_TBL_NUMBER
759: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
760: , x_result_type OUT NOCOPY VARCHAR2
761: )
762: IS
763: BEGIN

Line 786: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

782: -------------------------------------------------------------------------------
783: PROCEDURE gl_encumbered_date_not_null(
784: p_dist_id_tbl IN PO_TBL_NUMBER
785: , p_gl_encumbered_date_tbl IN PO_TBL_DATE
786: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
787: , x_result_type OUT NOCOPY VARCHAR2
788: )
789: IS
790: BEGIN

Line 815: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

811: p_dist_id_tbl IN PO_TBL_NUMBER
812: , p_org_id_tbl IN PO_TBL_NUMBER
813: , p_gl_encumbered_date_tbl IN PO_TBL_DATE
814: , p_dist_type_tbl IN PO_TBL_VARCHAR30 --Bug 14664343
815: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
816: , x_result_type OUT NOCOPY VARCHAR2
817: )
818: IS
819: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;

Line 827: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

823: l_gl_encumbered_date DATE;
824: BEGIN
825:
826: IF (x_results IS NULL) THEN
827: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
828: END IF;
829:
830: l_results_count := x_results.result_type.COUNT;
831:

Line 907: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

903: , p_task_id_tbl IN PO_TBL_NUMBER
904: , p_award_number_tbl IN PO_TBL_VARCHAR2000
905: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
906: , p_expenditure_item_date_tbl IN PO_TBL_DATE
907: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
908: , x_result_type OUT NOCOPY VARCHAR2
909: )
910: IS
911: l_failure_dist_id_tbl PO_TBL_NUMBER;

Line 918: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

914:
915: BEGIN
916:
917: IF (x_results IS NULL) THEN
918: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
919: END IF;
920:
921: l_results_count := x_results.result_type.COUNT;
922:

Line 983: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

979: , p_attribute12_tbl IN PO_TBL_VARCHAR2000
980: , p_attribute13_tbl IN PO_TBL_VARCHAR2000
981: , p_attribute14_tbl IN PO_TBL_VARCHAR2000
982: , p_attribute15_tbl IN PO_TBL_VARCHAR2000
983: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
984: , x_result_type OUT NOCOPY VARCHAR2
985: )
986: IS
987: d_mod CONSTANT VARCHAR2(100) := D_check_fv_validations;

Line 1004: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

1000: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1001: END IF;
1002:
1003: IF (x_results IS NULL) THEN
1004: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1005: END IF;
1006:
1007: l_results_count := x_results.result_type.COUNT;
1008:

Line 1104: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1100: , p_org_id_tbl IN PO_TBL_NUMBER
1101: , p_style_id_tbl IN PO_TBL_NUMBER
1102: , p_partial_funded_flag_tbl IN PO_TBL_VARCHAR1
1103: , p_funded_value_tbl IN PO_TBL_NUMBER
1104: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1105: , x_result_type OUT NOCOPY VARCHAR2
1106: )
1107: IS
1108: d_mod CONSTANT VARCHAR2(100) := D_funded_value_ge_zero;

Line 1124: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

1120: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1121: END IF;
1122:
1123: IF (x_results IS NULL) THEN
1124: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1125: END IF;
1126:
1127: l_results_count := x_results.result_type.COUNT;
1128:

Line 1188: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1184: , p_amount_ordered_tbl IN PO_TBL_NUMBER
1185: , p_price_override_tbl IN PO_TBL_NUMBER
1186: , p_nonrecoverable_tax_tbl IN PO_TBL_NUMBER
1187: , p_rate_tbl IN PO_TBL_NUMBER
1188: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1189: , x_result_type OUT NOCOPY VARCHAR2
1190: )
1191: IS
1192: d_mod CONSTANT VARCHAR2(100) := D_funded_val_le_tot_order_val;

Line 1221: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

1217: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1218: END IF;
1219:
1220: IF (x_results IS NULL) THEN
1221: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1222: END IF;
1223:
1224: l_results_count := x_results.result_type.COUNT;
1225:

Line 1321: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1317: , p_style_id_tbl IN PO_TBL_NUMBER
1318: , p_quantity_funded_tbl IN PO_TBL_NUMBER
1319: , p_quantity_billed_tbl IN PO_TBL_NUMBER
1320: , p_quantity_delivered_tbl IN PO_TBL_NUMBER
1321: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1322: , x_result_type OUT NOCOPY VARCHAR2
1323: )
1324: IS
1325: d_mod CONSTANT VARCHAR2(100) := D_qty_funded_ge_exc_qty;

Line 1342: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

1338: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1339: END IF;
1340:
1341: IF (x_results IS NULL) THEN
1342: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1343: END IF;
1344:
1345: l_results_count := x_results.result_type.COUNT;
1346:

Line 1416: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1412: , p_amount_funded_tbl IN PO_TBL_NUMBER
1413: , p_amount_billed_tbl IN PO_TBL_NUMBER
1414: , p_amount_delivered_tbl IN PO_TBL_NUMBER
1415: , p_line_matching_basis_tbl IN PO_TBL_VARCHAR30 --bug 13773450
1416: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1417: , x_result_type OUT NOCOPY VARCHAR2
1418: )
1419: IS
1420: d_mod CONSTANT VARCHAR2(100) := D_amount_funded_ge_exc_amount;

Line 1437: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

1433: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1434: END IF;
1435:
1436: IF (x_results IS NULL) THEN
1437: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1438: END IF;
1439:
1440: l_results_count := x_results.result_type.COUNT;
1441:

Line 1511: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1507: , p_org_id_tbl IN PO_TBL_NUMBER
1508: , p_style_id_tbl IN PO_TBL_NUMBER
1509: , p_funded_value_tbl IN PO_TBL_NUMBER
1510: , p_req_distribution_id_tbl IN PO_TBL_NUMBER
1511: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1512: , x_result_type OUT NOCOPY VARCHAR2
1513: )
1514: IS
1515: d_mod CONSTANT VARCHAR2(100) := D_funded_value_gt_backing_req;

Line 1532: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

1528: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1529: END IF;
1530:
1531: IF (x_results IS NULL) THEN
1532: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1533: END IF;
1534:
1535: l_results_count := x_results.result_type.COUNT;
1536:

Line 1611: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1607: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
1608: , p_expenditure_org_id_tbl IN PO_TBL_NUMBER
1609: , p_expenditure_item_date_tbl IN PO_TBL_DATE
1610: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
1611: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1612: , x_result_type OUT NOCOPY VARCHAR2
1613: )
1614: IS
1615: d_mod CONSTANT VARCHAR2(100) := D_check_proj_rel_validations;

Line 1637: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

1633: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1634: END IF;
1635:
1636: IF (x_results IS NULL) THEN
1637: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1638: END IF;
1639:
1640: l_results_count := x_results.result_type.COUNT;
1641:

Line 1928: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE ,

1924: p_quantity_ordered_tbl IN PO_TBL_NUMBER,
1925: p_amt_ordered_tbl IN PO_TBL_NUMBER,
1926: p_old_qty_ordered_tbl IN PO_TBL_NUMBER,
1927: p_change_status_tbl IN PO_TBL_VARCHAR30,
1928: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE ,
1929: x_result_type OUT NOCOPY VARCHAR2)
1930:
1931: IS
1932: d_mod CONSTANT VARCHAR2(100) := D_check_dist_val_inc_for_par;

Line 1944: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

1940: PO_LOG.proc_begin(d_mod);
1941: END IF;
1942:
1943: IF (x_results IS NULL) THEN
1944: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1945: END IF;
1946:
1947: l_results_count := x_results.result_type.COUNT;
1948:

Line 2007: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

2003:
2004: PROCEDURE check_clin_slin_funding(
2005: p_intf_dist_id_tbl IN PO_TBL_NUMBER,
2006: --p_dist_id_tbl IN PO_TBL_NUMBER,
2007: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2008: x_result_type OUT NOCOPY VARCHAR2)
2009: IS
2010:
2011: d_mod CONSTANT VARCHAR2(100) := D_check_clin_slin_funding;

Line 2077: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

2073:
2074: PROCEDURE validate_defence_funding(
2075: p_intf_dist_id_tbl IN PO_TBL_NUMBER,
2076: p_clm_defence_funding_tbl IN PO_TBL_VARCHAR30,
2077: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2078: x_result_type OUT NOCOPY VARCHAR2)
2079: IS
2080:
2081: d_mod CONSTANT VARCHAR2(100) := D_validate_defence_funding;

Line 2099: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

2095: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_intf_dist_id_tbl);
2096: END IF;
2097:
2098: IF (x_results IS NULL) THEN
2099: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2100: END IF;
2101: --loop through each distribution that corresponds to a slin
2102: FOR i IN 1..p_intf_dist_id_tbl.COUNT
2103: LOOP

Line 2154: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

2150:
2151:
2152: PROCEDURE validate_option_distribution(
2153: p_intf_dist_id_tbl IN PO_TBL_NUMBER,
2154: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2155: x_result_type OUT NOCOPY VARCHAR2)
2156: IS
2157:
2158: d_mod CONSTANT VARCHAR2(100) := D_validate_option_distribution;

Line 2175: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

2171: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_intf_dist_id_tbl);
2172: END IF;
2173:
2174: IF (x_results IS NULL) THEN
2175: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2176: END IF;
2177:
2178: -- Put the stored data for these ids into the temp table.
2179: l_data_key := PO_CORE_S.get_session_gt_nextval();