APPS.PO_DOCUMENT_UPDATE_PVT dependencies on MTL_GRADES

Line 3048: l_new_preferred_grade mtl_grades.grade_code%TYPE;

3044:
3045: l_new_amt NUMBER;
3046: l_new_promised_date DATE;
3047: l_delete_record VARCHAR2(1);
3048: l_new_preferred_grade mtl_grades.grade_code%TYPE;
3049: l_new_preferred_qty PO_LINE_LOCATIONS.quantity%TYPE;
3050: l_shipment_changes po_shipments_rec_type;
3051:
3052: l_new_sec_uom PO_LINES.secondary_unit_of_measure%TYPE;

Line 5148: FROM mtl_grades

5144: /* sschinch 09/08/04 begin INVCONV */
5145:
5146: CURSOR Cur_val_grade(p_grade VARCHAR2) IS
5147: SELECT grade_code
5148: FROM mtl_grades
5149: WHERE grade_code = p_grade;
5150: /* sschinch 09/08/04 end INVCONV */
5151:
5152: l_has_ga_ref PO_HEADERS.global_agreement_flag%TYPE;

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

5167: l_last_msg_list_index NUMBER;
5168: l_return_status VARCHAR2(1);
5169: l_price_updateable VARCHAR2(1);
5170: l_retroactive_price_change VARCHAR2(1);
5171: l_grade MTL_GRADES.grade_code%TYPE ; -- sschinch INVCONV
5172: l_new_preferred_grade MTL_GRADES.grade_code%TYPE; -- sschinch INVCONV
5173: l_advance_amount PO_LINE_LOCATIONS_ALL.AMOUNT%TYPE; /* << Complex work changes for R12 >> */
5174: BEGIN
5175: IF (g_fnd_debug = 'Y') THEN

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

5168: l_return_status VARCHAR2(1);
5169: l_price_updateable VARCHAR2(1);
5170: l_retroactive_price_change VARCHAR2(1);
5171: l_grade MTL_GRADES.grade_code%TYPE ; -- sschinch INVCONV
5172: l_new_preferred_grade MTL_GRADES.grade_code%TYPE; -- sschinch INVCONV
5173: l_advance_amount PO_LINE_LOCATIONS_ALL.AMOUNT%TYPE; /* << Complex work changes for R12 >> */
5174: BEGIN
5175: IF (g_fnd_debug = 'Y') THEN
5176: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 5648: p_table_name => 'MTL_GRADES',

5644: IF (l_grade IS NULL) THEN
5645: add_error ( p_api_errors => g_api_errors,
5646: x_return_status => x_return_status,
5647: p_message_name => 'INV_INVALID_GRADE_CODE',
5648: p_table_name => 'MTL_GRADES',
5649: p_column_name => NULL,
5650: p_entity_type => G_ENTITY_TYPE_LINES,
5651: p_entity_id => i );
5652: END IF;

Line 5694: FROM mtl_grades

5690: /* sschinch 09/08/04 begin INVCONV */
5691:
5692: CURSOR Cur_val_grade(p_grade VARCHAR2) IS
5693: SELECT grade_code
5694: FROM mtl_grades
5695: WHERE grade_code = p_grade;
5696: /* sschinch 09/08/04 end INVCONV */
5697:
5698: l_proc_name CONSTANT VARCHAR2(30) := 'VALIDATE_SHIPMENT_CHANGES';

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

5732: l_return_status VARCHAR2(1);
5733: l_price_updateable VARCHAR2(1);
5734: l_retroactive_price_change VARCHAR2(1);
5735:
5736: l_grade MTL_GRADES.grade_code%TYPE ; -- sschinch INVCONV
5737: l_new_preferred_grade MTL_GRADES.grade_code%TYPE; -- INVCONV
5738: l_new_secondary_qty PO_LINE_LOCATIONS.SECONDARY_QUANTITY%TYPE; -- INVCONV
5739:
5740: BEGIN

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

5733: l_price_updateable VARCHAR2(1);
5734: l_retroactive_price_change VARCHAR2(1);
5735:
5736: l_grade MTL_GRADES.grade_code%TYPE ; -- sschinch INVCONV
5737: l_new_preferred_grade MTL_GRADES.grade_code%TYPE; -- INVCONV
5738: l_new_secondary_qty PO_LINE_LOCATIONS.SECONDARY_QUANTITY%TYPE; -- INVCONV
5739:
5740: BEGIN
5741: IF (g_fnd_debug = 'Y') THEN

Line 6006: p_table_name => 'MTL_GRADES',

6002: IF (l_grade IS NULL) THEN
6003: add_error ( p_api_errors => g_api_errors,
6004: x_return_status => x_return_status,
6005: p_message_name => 'INV_INVALID_GRADE_CODE',
6006: p_table_name => 'MTL_GRADES',
6007: p_entity_type => G_ENTITY_TYPE_SHIPMENTS,
6008: p_entity_id => i );
6009: END IF;
6010: END IF;