DBA Data[Home] [Help]

APPS.OE_CNCL_UTIL dependencies on OE_GLOBALS

Line 735: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE

731: -- Retrieve the sold_to_org_id if not passed on the header record. This
732: -- will be needed by the value_to_id functions for related fields.
733: -- For e.g. oe_value_to_id.ship_to_org_id requires sold_to_org_id
734:
735: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
736: AND p_x_header_rec.sold_to_org_id = FND_API.G_MISS_NUM
737: THEN
738:
739: SELECT SOLD_TO_ORG_ID

Line 2099: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

2095:
2096: IF p_x_line_rec.sold_to_org_id = FND_API.G_MISS_NUM
2097: THEN
2098:
2099: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2100:
2101: SELECT SOLD_TO_ORG_ID
2102: INTO l_sold_to_org_id
2103: FROM OE_ORDER_HEADERS

Line 2106: ELSIF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

2102: INTO l_sold_to_org_id
2103: FROM OE_ORDER_HEADERS
2104: WHERE HEADER_ID = p_x_line_rec.header_id;
2105:
2106: ELSIF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2107:
2108: SELECT SOLD_TO_ORG_ID
2109: INTO l_sold_to_org_id
2110: FROM OE_ORDER_LINES

Line 2263: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE

2259: -- Retrieve the org_ids if not passed on the line record. These
2260: -- IDs will be needed by the value_to_id functions for CONTACT fields.
2261: -- For e.g. oe_value_to_id.ship_to_contact_id requires ship_to_org_id
2262:
2263: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2264: AND ( p_x_line_rec.ship_to_org_id = FND_API.G_MISS_NUM
2265: OR p_x_line_rec.invoice_to_org_id = FND_API.G_MISS_NUM
2266: OR p_x_line_rec.deliver_to_org_id = FND_API.G_MISS_NUM )
2267: THEN