APPS.PO_DOCUMENT_UPDATE_PVT dependencies on MTL_GRADES

Line 3071: l_new_preferred_grade mtl_grades.grade_code%TYPE;

3067:
3068: l_new_amt NUMBER;
3069: l_new_promised_date DATE;
3070: l_delete_record VARCHAR2(1);
3071: l_new_preferred_grade mtl_grades.grade_code%TYPE;
3072: l_new_preferred_qty PO_LINE_LOCATIONS.quantity%TYPE;
3073: l_shipment_changes po_shipments_rec_type;
3074:
3075: l_new_sec_uom PO_LINES.secondary_unit_of_measure%TYPE;

Line 5187: FROM mtl_grades

5183: /* sschinch 09/08/04 begin INVCONV */
5184:
5185: CURSOR Cur_val_grade(p_grade VARCHAR2) IS
5186: SELECT grade_code
5187: FROM mtl_grades
5188: WHERE grade_code = p_grade;
5189: /* sschinch 09/08/04 end INVCONV */
5190:
5191: l_has_ga_ref PO_HEADERS.global_agreement_flag%TYPE;

Line 5210: l_grade MTL_GRADES.grade_code%TYPE ; -- sschinch INVCONV

5206: l_last_msg_list_index NUMBER;
5207: l_return_status VARCHAR2(1);
5208: l_price_updateable VARCHAR2(1);
5209: l_retroactive_price_change VARCHAR2(1);
5210: l_grade MTL_GRADES.grade_code%TYPE ; -- sschinch INVCONV
5211: l_new_preferred_grade MTL_GRADES.grade_code%TYPE; -- sschinch INVCONV
5212: l_advance_amount PO_LINE_LOCATIONS_ALL.AMOUNT%TYPE; /* << Complex work changes for R12 >> */
5213: l_orig_qty PO_LINES.quantity%TYPE; --
5214:

Line 5211: l_new_preferred_grade MTL_GRADES.grade_code%TYPE; -- sschinch INVCONV

5207: l_return_status VARCHAR2(1);
5208: l_price_updateable VARCHAR2(1);
5209: l_retroactive_price_change VARCHAR2(1);
5210: l_grade MTL_GRADES.grade_code%TYPE ; -- sschinch INVCONV
5211: l_new_preferred_grade MTL_GRADES.grade_code%TYPE; -- sschinch INVCONV
5212: l_advance_amount PO_LINE_LOCATIONS_ALL.AMOUNT%TYPE; /* << Complex work changes for R12 >> */
5213: l_orig_qty PO_LINES.quantity%TYPE; --
5214:
5215: BEGIN

Line 5693: p_table_name => 'MTL_GRADES',

5689: IF (l_grade IS NULL) THEN
5690: add_error ( p_api_errors => g_api_errors,
5691: x_return_status => x_return_status,
5692: p_message_name => 'INV_INVALID_GRADE_CODE',
5693: p_table_name => 'MTL_GRADES',
5694: p_column_name => NULL,
5695: p_entity_type => G_ENTITY_TYPE_LINES,
5696: p_entity_id => i );
5697: END IF;

Line 5739: FROM mtl_grades

5735: /* sschinch 09/08/04 begin INVCONV */
5736:
5737: CURSOR Cur_val_grade(p_grade VARCHAR2) IS
5738: SELECT grade_code
5739: FROM mtl_grades
5740: WHERE grade_code = p_grade;
5741: /* sschinch 09/08/04 end INVCONV */
5742:
5743: l_proc_name CONSTANT VARCHAR2(30) := 'VALIDATE_SHIPMENT_CHANGES';

Line 5781: l_grade MTL_GRADES.grade_code%TYPE ; -- sschinch INVCONV

5777: l_return_status VARCHAR2(1);
5778: l_price_updateable VARCHAR2(1);
5779: l_retroactive_price_change VARCHAR2(1);
5780:
5781: l_grade MTL_GRADES.grade_code%TYPE ; -- sschinch INVCONV
5782: l_new_preferred_grade MTL_GRADES.grade_code%TYPE; -- INVCONV
5783: l_new_secondary_qty PO_LINE_LOCATIONS.SECONDARY_QUANTITY%TYPE; -- INVCONV
5784: l_orig_qty PO_LINE_LOCATIONS.quantity%TYPE; --
5785:

Line 5782: l_new_preferred_grade MTL_GRADES.grade_code%TYPE; -- INVCONV

5778: l_price_updateable VARCHAR2(1);
5779: l_retroactive_price_change VARCHAR2(1);
5780:
5781: l_grade MTL_GRADES.grade_code%TYPE ; -- sschinch INVCONV
5782: l_new_preferred_grade MTL_GRADES.grade_code%TYPE; -- INVCONV
5783: l_new_secondary_qty PO_LINE_LOCATIONS.SECONDARY_QUANTITY%TYPE; -- INVCONV
5784: l_orig_qty PO_LINE_LOCATIONS.quantity%TYPE; --
5785:
5786: BEGIN

Line 6056: p_table_name => 'MTL_GRADES',

6052: IF (l_grade IS NULL) THEN
6053: add_error ( p_api_errors => g_api_errors,
6054: x_return_status => x_return_status,
6055: p_message_name => 'INV_INVALID_GRADE_CODE',
6056: p_table_name => 'MTL_GRADES',
6057: p_entity_type => G_ENTITY_TYPE_SHIPMENTS,
6058: p_entity_id => i );
6059: END IF;
6060: END IF;