APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on STANDARD

Line 927: p_contract_type = 'STANDARD'

923: (
924: NVL (sel_group_type, g_invalid_string) <> 'GROUP' AND
925: sel_need_by_start_date IS NOT NULL AND
926: sel_need_by_start_date < nvl (p_close_bidding_date, SYSDATE) AND
927: p_contract_type = 'STANDARD'
928: )
929:
930: THEN INTO PON_INTERFACE_ERRORS
931: (

Line 964: p_contract_type = 'STANDARD' AND

960: (
961: NVL (sel_group_type, g_invalid_string) <> 'GROUP' AND
962: sel_need_by_date IS NULL AND
963: sel_need_by_start_date IS NULL AND
964: p_contract_type = 'STANDARD' AND
965: EXISTS (
966: SELECT
967: 'X'
968: FROM

Line 1409: p_contract_type = 'STANDARD' AND

1405: WHEN
1406: (
1407: g_document_type_required_rule('SHIP_TO_LOCATION') = 'Y' AND
1408: g_document_type_names (p_doctype_id) <> PON_CONTERMS_UTL_PVT.SRC_REQUEST_FOR_INFORMATION AND
1409: p_contract_type = 'STANDARD' AND
1410: NVL (sel_group_type, g_invalid_string) <> 'GROUP' AND
1411: nvl (sel_line_origination_code,g_invalid_string) <> 'REQUISITION' AND
1412: sel_ship_to_location_id IS NULL
1413: )

Line 1599: p_contract_type = 'STANDARD')

1595: nvl (sel_line_origination_code,g_invalid_string) <> 'REQUISITION' AND
1596: g_document_type_required_rule('SHIP_TO_LOCATION') = 'Y' AND
1597: ((nvl (sel_purchase_basis,g_invalid_string) <> g_temp_labor AND
1598: g_document_type_names (p_doctype_id) = PON_CONTERMS_UTL_PVT.SRC_REQUEST_FOR_INFORMATION) OR
1599: p_contract_type = 'STANDARD')
1600: )
1601: THEN INTO PON_INTERFACE_ERRORS
1602: (
1603: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,

Line 4909: ELSIF l_contract_type = 'STANDARD' THEN

4905: WHERE paip.auction_header_id = p_auction_header_id
4906: AND paip.line_type_id = plt.line_type_id (+)
4907: AND paip.group_type NOT IN ('GROUP','LOT_LINE');
4908:
4909: ELSIF l_contract_type = 'STANDARD' THEN
4910:
4911: INSERT ALL
4912: WHEN retainage_rate_percent IS NOT NULL AND (retainage_rate_percent < 0 OR retainage_rate_percent > 100) THEN
4913: INTO pon_interface_errors

Line 5576: END IF; -- End of if l_contract_type = 'STANDARD'

5572: END IF;
5573: Raise;
5574: END;
5575:
5576: END IF; -- End of if l_contract_type = 'STANDARD'
5577: END validate_complexwork_lines;
5578:
5579: PROCEDURE validate_payments (
5580: p_auction_header_id IN NUMBER,

Line 6699: IF p_progress_payment_type <> 'NONE' AND p_contract_type = 'STANDARD' THEN

6695: validate_complexwork_lines (
6696: p_auction_header_id, p_request_id, l_expiration_date, l_user_id, l_login_id,
6697: l_batch_id, p_fnd_currency_precision);
6698:
6699: IF p_progress_payment_type <> 'NONE' AND p_contract_type = 'STANDARD' THEN
6700: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6701: FND_LOG.string(log_level => FND_LOG.level_statement,
6702: module => g_module_prefix || 'VALIDATE_LINES',
6703: message => 'Validating payments:');

Line 7144: -- standard who columns

7140: WHERE AUCTION_HEADER_ID = p_auction_header_id
7141: AND LINE_NUMBER = PAIP.LINE_NUMBER
7142: AND SEQUENCE_NUMBER = -10
7143: AND ROWNUM = 1), 'N'),
7144: -- standard who columns
7145: last_update_date = sysdate,
7146: last_update_login = p_login_id,
7147: last_updated_by = p_user_id
7148: WHERE

Line 7388: -- standard who columns

7384: PROJECT_AWARD_ID = null,
7385: PROJECT_EXPENDITURE_TYPE = null,
7386: PROJECT_EXP_ORGANIZATION_ID = null,
7387: PROJECT_EXPENDITURE_ITEM_DATE = null,
7388: -- standard who columns
7389: last_update_date = sysdate,
7390: last_update_login = p_login_id,
7391: last_updated_by = p_user_id
7392: WHERE