DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_GROUPING_PVT dependencies on PO_CORE_S

Line 389: l_key := PO_CORE_S.get_session_gt_nextval;

385: l_line_combined_flag_tbl := PO_TBL_VARCHAR1();
386: l_line_combined_flag_tbl.EXTEND(l_num_lines);
387:
388: -- Get a new session key for use with the temp table.
389: l_key := PO_CORE_S.get_session_gt_nextval;
390:
391: -- Insert req line ID and PO line num of all lines into temp table.
392: FORALL i IN 1..l_num_lines
393: INSERT INTO po_session_gt(

Line 1096: AND NOT PO_CORE_S.is_equal_minutes(

1092: x_token_value := NULL;
1093:
1094: -- Check need-by date attributes
1095: IF ((NVL(p_need_by_grouping_profile, 'Y') = 'Y')
1096: AND NOT PO_CORE_S.is_equal_minutes(
1097: p_delivery_one.need_by_date,
1098: p_delivery_two.need_by_date))
1099: THEN
1100: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';

Line 1117: IF (NOT PO_CORE_S.is_equal(

1113: -- Check ship-to attributes
1114: IF (NVL(p_ship_to_grouping_profile, 'Y') = 'Y')
1115: THEN
1116: -- Check ship-to organization ID attributes
1117: IF (NOT PO_CORE_S.is_equal(
1118: p_delivery_one.ship_to_organization_id,
1119: p_delivery_two.ship_to_organization_id))
1120: THEN
1121: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';

Line 1135: IF (NOT PO_CORE_S.is_equal(

1131: RETURN;
1132: END IF;
1133:
1134: -- Check ship-to location ID attributes
1135: IF (NOT PO_CORE_S.is_equal(
1136: p_delivery_one.ship_to_location_id,
1137: p_delivery_two.ship_to_location_id))
1138: THEN
1139: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';

Line 1154: IF (NOT PO_CORE_S.is_equal(

1150: END IF;
1151: END IF;
1152:
1153: -- Check consigned flag attributes which are set to 'N' if NULL
1154: IF (NOT PO_CORE_S.is_equal(
1155: NVL(p_delivery_one.consigned_flag, 'N'),
1156: NVL(p_delivery_two.consigned_flag, 'N')))
1157: THEN
1158: x_message_code := 'PO_ALL_CANT_COMB_CONSIGNED';

Line 1596: IF (NOT PO_CORE_S.is_equal(p_line_one.item_id, p_line_two.item_id)

1592: x_token_value := NULL;
1593:
1594: -- Check line-level attributes. If any mismatches are found, set error
1595: -- message values and skip the rest of the checks.
1596: IF (NOT PO_CORE_S.is_equal(p_line_one.item_id, p_line_two.item_id)
1597: OR (p_line_one.item_id IS NULL AND p_line_two.item_id IS NULL
1598: AND NOT PO_CORE_S.is_equal(
1599: p_line_one.item_description,
1600: p_line_two.item_description)))

Line 1598: AND NOT PO_CORE_S.is_equal(

1594: -- Check line-level attributes. If any mismatches are found, set error
1595: -- message values and skip the rest of the checks.
1596: IF (NOT PO_CORE_S.is_equal(p_line_one.item_id, p_line_two.item_id)
1597: OR (p_line_one.item_id IS NULL AND p_line_two.item_id IS NULL
1598: AND NOT PO_CORE_S.is_equal(
1599: p_line_one.item_description,
1600: p_line_two.item_description)))
1601: THEN
1602: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';

Line 1615: IF (NOT PO_CORE_S.is_equal(

1611:
1612: RETURN;
1613: END IF;
1614:
1615: IF (NOT PO_CORE_S.is_equal(
1616: p_line_one.item_revision,
1617: p_line_two.item_revision))
1618: THEN
1619: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';

Line 1635: (NOT PO_CORE_S.is_equal(

1631:
1632: --BUG 5641147 : Donot group for RATE and FIXED PRICE lines
1633: IF p_line_two.order_type_lookup_code IN ('RATE','FIXED PRICE')
1634: OR
1635: (NOT PO_CORE_S.is_equal(
1636: p_line_one.order_type_lookup_code,
1637: p_line_two.order_type_lookup_code
1638: )
1639: OR NOT PO_CORE_S.is_equal(

Line 1639: OR NOT PO_CORE_S.is_equal(

1635: (NOT PO_CORE_S.is_equal(
1636: p_line_one.order_type_lookup_code,
1637: p_line_two.order_type_lookup_code
1638: )
1639: OR NOT PO_CORE_S.is_equal(
1640: p_line_one.purchase_basis,
1641: p_line_two.purchase_basis
1642: )
1643: OR NOT PO_CORE_S.is_equal(

Line 1643: OR NOT PO_CORE_S.is_equal(

1639: OR NOT PO_CORE_S.is_equal(
1640: p_line_one.purchase_basis,
1641: p_line_two.purchase_basis
1642: )
1643: OR NOT PO_CORE_S.is_equal(
1644: p_line_one.matching_basis,
1645: p_line_two.matching_basis))
1646: THEN
1647: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';

Line 1660: IF (NOT PO_CORE_S.is_equal(

1656:
1657: RETURN;
1658: END IF;
1659:
1660: IF (NOT PO_CORE_S.is_equal(
1661: p_line_one.preferred_grade,
1662: p_line_two.preferred_grade))
1663: THEN
1664: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';

Line 1677: IF (NOT PO_CORE_S.is_equal(

1673:
1674: RETURN;
1675: END IF;
1676:
1677: IF (NOT PO_CORE_S.is_equal(
1678: p_line_one.unit_meas_lookup_code,
1679: p_line_two.unit_meas_lookup_code))
1680: THEN
1681: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';

Line 1694: IF (NOT PO_CORE_S.is_equal(

1690:
1691: RETURN;
1692: END IF;
1693:
1694: IF (NOT PO_CORE_S.is_equal(
1695: p_line_one.transaction_reason,
1696: p_line_two.transaction_reason))
1697: THEN
1698: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';

Line 1711: IF (NOT PO_CORE_S.is_equal(p_line_one.contract_id, p_line_two.contract_id))

1707:
1708: RETURN;
1709: END IF;
1710:
1711: IF (NOT PO_CORE_S.is_equal(p_line_one.contract_id, p_line_two.contract_id))
1712: THEN
1713: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
1714: x_token_name := 'REASON_FOR_DIFF';
1715: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_CONTRACT');

Line 1727: AND (NOT PO_CORE_S.is_equal(

1723: RETURN;
1724: END IF;
1725:
1726: IF (p_agreement_id IS NULL
1727: AND (NOT PO_CORE_S.is_equal(
1728: p_line_one.source_document_id,
1729: p_line_two.source_document_id
1730: )
1731: OR NOT PO_CORE_S.is_equal(

Line 1731: OR NOT PO_CORE_S.is_equal(

1727: AND (NOT PO_CORE_S.is_equal(
1728: p_line_one.source_document_id,
1729: p_line_two.source_document_id
1730: )
1731: OR NOT PO_CORE_S.is_equal(
1732: p_line_one.source_document_line_id,
1733: p_line_two.source_document_line_id)))
1734: THEN
1735: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';

Line 1778: IF (NOT PO_CORE_S.is_equal(

1774:
1775: RETURN;
1776: END IF;
1777:
1778: IF (NOT PO_CORE_S.is_equal(
1779: p_line_one.supplier_ref_number,
1780: p_line_two.supplier_ref_number))
1781: THEN
1782: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';

Line 2321: l_key := PO_CORE_S.get_session_gt_nextval;

2317: d_position := 10;
2318:
2319: -- Retrieve a new GT table key.
2320: --
2321: l_key := PO_CORE_S.get_session_gt_nextval;
2322:
2323: -- Get Profile Option values to be used in query.
2324: --
2325: l_need_by_grouping_profile := FND_PROFILE.value('PO_NEED_BY_GROUPING');