APPS.PO_VAL_LINES dependencies on PO_VALIDATION_RESULTS_GT

Line 396: INSERT INTO PO_VALIDATION_RESULTS_GT

392: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
393: END IF;
394:
395: FORALL i IN 1 .. p_line_id_tbl.COUNT
396: INSERT INTO PO_VALIDATION_RESULTS_GT
397: ( result_set_id
398: , entity_type
399: , entity_id
400: , column_name

Line 703: INSERT INTO PO_VALIDATION_RESULTS_GT

699: FOR i IN 1 .. p_line_id_tbl.Count LOOP
700: l_is_clm_po := PO_CLM_INTG_GRP.Is_clm_po(p_po_line_id => p_line_id_tbl(i));
701:
702: IF Nvl(l_is_clm_po,'N') = 'N' THEN
703: INSERT INTO PO_VALIDATION_RESULTS_GT
704: ( result_set_id
705: , entity_type
706: , entity_id
707: , column_name

Line 895: INSERT INTO PO_VALIDATION_RESULTS_GT

891:
892: d_progress := 40.0;
893:
894: FORALL i IN 1 .. p_line_id_tbl.COUNT
895: INSERT INTO PO_VALIDATION_RESULTS_GT
896: ( result_set_id
897: , entity_type
898: , entity_id
899: , column_name

Line 1260: INSERT INTO PO_VALIDATION_RESULTS_GT

1256:
1257: IF (l_po_vmi_display_warning = 'Y') THEN
1258:
1259: FORALL i in 1 ..p_line_id_tbl.COUNT
1260: INSERT INTO PO_VALIDATION_RESULTS_GT
1261: ( result_set_id
1262: , result_type
1263: , entity_type
1264: , entity_id

Line 2427: INSERT INTO PO_VALIDATION_RESULTS_GT

2423: -- PO_MESSAGE_S.PO_PO_QTY_LT_MILESTONE_BILL
2424: -- PO_MESSAGE_S.PO_PO_QTY_LT_MILESTONE_RECV
2425:
2426: FORALL i IN 1 .. p_line_id_tbl.COUNT
2427: INSERT INTO PO_VALIDATION_RESULTS_GT
2428: ( result_set_id
2429: , entity_type
2430: , entity_id
2431: , column_name

Line 2521: INSERT INTO PO_VALIDATION_RESULTS_GT

2517: -- : Fill in the following messages
2518: -- PO_MESSAGE_S.PO_PO_QTY_LT_MILESTONE_BILL
2519:
2520: FORALL i IN 1 .. p_line_id_tbl.COUNT
2521: INSERT INTO PO_VALIDATION_RESULTS_GT
2522: ( result_set_id
2523: , entity_type
2524: , entity_id
2525: , column_name

Line 2799: INSERT INTO PO_VALIDATION_RESULTS_GT

2795: l_id_tbl.trim(l_input_size-l_count);
2796: l_line_type_id_tbl.trim(l_input_size-l_count);
2797:
2798: FORALL i IN 1 .. l_id_tbl.COUNT
2799: INSERT INTO PO_VALIDATION_RESULTS_GT
2800: ( result_set_id
2801: , entity_type
2802: , entity_id
2803: , column_name

Line 3361: INSERT INTO PO_VALIDATION_RESULTS_GT

3357: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
3358: END IF;
3359:
3360: FORALL i IN 1 .. p_line_id_tbl.COUNT
3361: INSERT INTO PO_VALIDATION_RESULTS_GT
3362: ( result_set_id
3363: , entity_type
3364: , entity_id
3365: , column_name

Line 3884: INSERT INTO po_validation_results_gt

3880: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
3881: END IF;
3882:
3883: FORALL i IN 1..p_line_id_tbl.COUNT
3884: INSERT INTO po_validation_results_gt
3885: (result_set_id,
3886: entity_type,
3887: entity_id,
3888: message_name,

Line 4026: INSERT INTO PO_VALIDATION_RESULTS_GT

4022: , c_NEW
4023: );
4024:
4025: -- validate uniqueness of line_num_display
4026: INSERT INTO PO_VALIDATION_RESULTS_GT
4027: ( result_set_id
4028: , entity_type
4029: , entity_id
4030: , column_name

Line 4064: INSERT INTO PO_VALIDATION_RESULTS_GT

4060: END IF;
4061:
4062:
4063: -- validate SLIN numbers are in sync with CLIN numbers
4064: INSERT INTO PO_VALIDATION_RESULTS_GT
4065: ( result_set_id
4066: , entity_type
4067: , entity_id
4068: , column_name

Line 5141: INSERT INTO PO_VALIDATION_RESULTS_GT

5137: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
5138: END IF;
5139:
5140: FORALL i IN 1 .. p_line_id_tbl.COUNT
5141: INSERT INTO PO_VALIDATION_RESULTS_GT
5142: ( result_set_id
5143: , entity_type
5144: , entity_id
5145: , column_name