APPS.OE_AGREEMENT_UTIL dependencies on OE_AGREEMENTS

Line 1086: OE_AGREEMENTS_PKG.UPDATE_ROW (

1082: IF QP_security.check_function( p_function_name => QP_Security.G_FUNCTION_UPDATE,
1083: p_instance_type => QP_Security.G_AGREEMENT_OBJECT,
1084: p_instance_pk1 => p_Agreement_rec.price_list_id) <> 'F' THEN
1085:
1086: OE_AGREEMENTS_PKG.UPDATE_ROW (
1087: p_Agreement_rec.agreement_id
1088: , p_Agreement_rec.tp_attribute2
1089: , p_Agreement_rec.tp_attribute3
1090: , p_Agreement_rec.tp_attribute4

Line 1162: UPDATE OE_AGREEMENTS

1158: END IF;
1159:
1160:
1161: /*
1162: UPDATE OE_AGREEMENTS
1163: SET ACCOUNTING_RULE_ID = p_Agreement_rec.accounting_rule_id
1164: , AGREEMENT_CONTACT_ID = p_Agreement_rec.agreement_contact_id
1165: , AGREEMENT_ID = p_Agreement_rec.agreement_id
1166: , AGREEMENT_NUM = p_Agreement_rec.agreement_num

Line 1242: OE_AGREEMENTS_PKG.INSERT_ROW ( x_row_id

1238:
1239: oe_debug_pub.add('Entering OE_Agreement_Util.Insert_Row');
1240: --
1241:
1242: OE_AGREEMENTS_PKG.INSERT_ROW ( x_row_id
1243: , p_Agreement_rec.agreement_id
1244: , p_Agreement_rec.tp_attribute2
1245: , p_Agreement_rec.tp_attribute3
1246: , p_Agreement_rec.tp_attribute4

Line 1313: INSERT INTO OE_AGREEMENTS

1309:
1310:
1311: -- Code commented :: using new package
1312: /*
1313: INSERT INTO OE_AGREEMENTS
1314: ( ACCOUNTING_RULE_ID
1315: , AGREEMENT_CONTACT_ID
1316: , AGREEMENT_ID
1317: , AGREEMENT_NUM

Line 1468: from oe_agreements_b, qp_list_headers q

1464: -- oe_debug_pub.add('p_Agreement_Lines_Delete_Flag :'||to_char(p_Agreement_Lines_Delete_Flag));
1465: -- Added for 2321498
1466: SELECT price_list_id, q.list_type_code into
1467: l_Price_List_id, l_list_type_code
1468: from oe_agreements_b, qp_list_headers q
1469: where agreement_id = p_agreement_id And
1470: price_list_id = q.list_header_id;
1471:
1472:

Line 1483: from oe_agreements_b

1479: If this flag is TRUE then Delete Price List
1480:
1481: SELECT price_list_id into
1482: l_Price_List_id
1483: from oe_agreements_b
1484: where agreement_id = p_agreement_id;
1485:
1486: if l_Price_List_id is NOT NULL THEN
1487:

Line 1527: OE_AGREEMENTS_PKG.DELETE_ROW( p_agreement_id );

1523: End;
1524:
1525: oe_dEbug_pub.add('Deleting Agreement because agreement is not associated with an order or order line');
1526:
1527: OE_AGREEMENTS_PKG.DELETE_ROW( p_agreement_id );
1528: x_return_status := FND_API.G_RET_STS_SUCCESS;
1529: else
1530: oe_debug_pub.add('Did not delete agreement');
1531: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1645: FROM OE_AGREEMENTS

1641: , TERM_ID
1642: , AGREEMENT_SOURCE_CODE
1643: , ORIG_SYSTEM_AGR_ID
1644: , INVOICE_TO_CUSTOMER_ID -- Added for bug#4029589
1645: FROM OE_AGREEMENTS
1646: WHERE ( AGREEMENT_ID = p_agreement_id
1647: )
1648: ;
1649:

Line 1788: OE_AGREEMENTS_PKG.UPDATE_ROW (

1784: BEGIN
1785:
1786: oe_debug_pub.add('Entering OE_Agreement_Util.Lock_Row');
1787:
1788: OE_AGREEMENTS_PKG.UPDATE_ROW (
1789: p_Agreement_rec.agreement_id
1790: , p_Agreement_rec.tp_attribute2
1791: , p_Agreement_rec.tp_attribute3
1792: , p_Agreement_rec.tp_attribute4

Line 1946: FROM OE_AGREEMENTS

1942: , l_Agreement_rec.ship_method_code
1943: , l_Agreement_rec.signature_date
1944: , l_Agreement_rec.start_date_active
1945: , l_Agreement_rec.term_id
1946: FROM OE_AGREEMENTS
1947: WHERE AGREEMENT_ID = p_Agreement_rec.agreement_id
1948: FOR UPDATE NOWAIT;
1949: */
1950: -- Row locked. Compare IN attributes to DB attributes.