eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_VAL_HEADERS dependencies on STANDARD

Line 32: c_STANDARD CONSTANT VARCHAR2(30) := 'STANDARD';

28: c_MANUAL CONSTANT VARCHAR2(30) := 'MANUAL';
29: c_NUMERIC CONSTANT VARCHAR2(30) := 'NUMERIC';
30: c_PLANNED CONSTANT VARCHAR2(30) := 'PLANNED';
31: c_PO CONSTANT VARCHAR2(30) := 'PO';
32: c_STANDARD CONSTANT VARCHAR2(30) := 'STANDARD';
33: c_SUCCESS CONSTANT VARCHAR2(30) := 'SUCCESS';
34: c_User CONSTANT VARCHAR2(30) := 'User';
35: c_EMAIL CONSTANT VARCHAR2(30) := 'EMAIL';
36:

Line 39: c_CLM_STANDARD_FORM VARCHAR2(30) := 'CLM_STANDARD_FORM';

35: c_EMAIL CONSTANT VARCHAR2(30) := 'EMAIL';
36:
37: -- For CLM PO Fed Fields
38: c_CLM_MAX_ORD_AMT CONSTANT VARCHAR2(30) := 'CLM_MAX_ORDER_AMOUNT';
39: c_CLM_STANDARD_FORM VARCHAR2(30) := 'CLM_STANDARD_FORM';
40: c_CLM_DOCUMENT_FORMAT VARCHAR2(30) :='CLM_DOCUMENT_FORMAT';
41: c_MIN_GUAR_PERC VARCHAR2(30) := 'CLM_MIN_GUAR_AWARD_AMT_PERCENT';
42:
43: --CLM PDOI Integration

Line 147: D_validate_clm_standard_form CONSTANT VARCHAR2(100) :=

143: D_print_form_format_valid CONSTANT VARCHAR2(100) :=
144: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'print_form_format_valid');
145:
146: --CLM PDOI Integration
147: D_validate_clm_standard_form CONSTANT VARCHAR2(100) :=
148: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'valid_clm_standard_form');
149: D_validate_clm_document_format CONSTANT VARCHAR2(100) :=
150: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'valid_clm_document_format');
151: D_validate_source_idv CONSTANT VARCHAR2(100) :=

Line 148: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'valid_clm_standard_form');

144: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'print_form_format_valid');
145:
146: --CLM PDOI Integration
147: D_validate_clm_standard_form CONSTANT VARCHAR2(100) :=
148: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'valid_clm_standard_form');
149: D_validate_clm_document_format CONSTANT VARCHAR2(100) :=
150: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'valid_clm_document_format');
151: D_validate_source_idv CONSTANT VARCHAR2(100) :=
152: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_source_idv');

Line 1180: -- For CLM standard form and document format cannot be null

1176: END max_ord_amt_gt_min;
1177:
1178:
1179: ---------------------------------------------------------------------------
1180: -- For CLM standard form and document format cannot be null
1181: ---------------------------------------------------------------------------
1182: PROCEDURE print_form_format_valid(
1183: p_header_id_tbl IN PO_TBL_NUMBER
1184: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

Line 1187: , p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000

1183: p_header_id_tbl IN PO_TBL_NUMBER
1184: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1185: , p_style_id_tbl IN PO_TBL_NUMBER
1186: , p_draft_type_tbl IN PO_TBL_VARCHAR30
1187: , p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000
1188: , p_document_format_tbl IN PO_TBL_VARCHAR2000
1189: , p_clm_src_doc_id_tbl IN PO_TBL_NUMBER
1190: , p_clm_ext_idv_tbl IN PO_TBL_VARCHAR2000
1191: , p_clm_award_type_tbl IN PO_TBL_VARCHAR30 -- bug 10389450

Line 1202: PO_LOG.proc_begin(d_mod,'p_clm_standard_form_tbl',p_clm_standard_form_tbl);

1198:
1199: IF PO_LOG.d_proc THEN
1200: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1201: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1202: PO_LOG.proc_begin(d_mod,'p_clm_standard_form_tbl',p_clm_standard_form_tbl);
1203: PO_LOG.proc_begin(d_mod,'p_document_format_tbl',p_document_format_tbl);
1204: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1205: END IF;
1206:

Line 1225: , decode(nvl(p_document_format_tbl(i), ''), '', c_CLM_DOCUMENT_FORMAT, c_CLM_STANDARD_FORM)

1221: SELECT
1222: x_result_set_id
1223: , c_entity_type_HEADER
1224: , p_header_id_tbl(i)
1225: , decode(nvl(p_document_format_tbl(i), '*'), '*', c_CLM_DOCUMENT_FORMAT, c_CLM_STANDARD_FORM)
1226: , null
1227: , PO_MESSAGE_S.PO_PRINT_FORM_FORMAT_INVALID
1228: FROM PO_DOC_STYLE_HEADERS PDSH
1229: WHERE PDSH.style_id = p_style_id_tbl(i)

Line 1236: decode(p_type_lookup_code_tbl(i), c_STANDARD,

1232: SELECT 1
1233: FROM po_print_form_formats ppff
1234: WHERE ppff.document_type = decode(nvl(p_draft_type_tbl(i), '*'),
1235: 'MOD', 'PO_MOD_STD_FORM', -- bug 10389450 start
1236: decode(p_type_lookup_code_tbl(i), c_STANDARD,
1237: decode(p_clm_award_type_tbl(i),
1238: 'BPA_CALL', 'PO_DEL_ORD_STD_FORM',
1239: 'DELIVERY_ORD', 'PO_DEL_ORD_STD_FORM',
1240: 'PO_AWARD_STD_FORM'),

Line 1242: AND ppff.standard_form = p_clm_standard_form_tbl(i)

1238: 'BPA_CALL', 'PO_DEL_ORD_STD_FORM',
1239: 'DELIVERY_ORD', 'PO_DEL_ORD_STD_FORM',
1240: 'PO_AWARD_STD_FORM'),
1241: 'PO_IDV_STD_FORM')) -- bug 10389450 end
1242: AND ppff.standard_form = p_clm_standard_form_tbl(i)
1243: AND ppff.document_format = p_document_format_tbl(i)
1244: AND trunc(sysdate) <= trunc(nvl(ppff.inactive_date, sysdate +1))
1245: )
1246: AND Nvl(p_draft_type_tbl(i),'*') <> 'PAR'; --

Line 1763: AND HEADER.type_lookup_code IN (c_STANDARD,c_PLANNED,c_CONTRACT,c_BLANKET)

1759: FROM PO_HEADERS_ALL HEADER
1760: WHERE
1761: HEADER.org_id = SES.num2
1762: AND HEADER.segment1 = SES.index_char1
1763: AND HEADER.type_lookup_code IN (c_STANDARD,c_PLANNED,c_CONTRACT,c_BLANKET)
1764: AND HEADER.po_header_id <> SES.num1
1765: )
1766: OR
1767: -- Check for previously purged documents.

Line 1774: AND DELETED_HEADER.type_lookup_code IN (c_STANDARD,c_PLANNED,c_CONTRACT,c_BLANKET)

1770: FROM PO_HISTORY_POS_ALL DELETED_HEADER
1771: WHERE
1772: DELETED_HEADER.org_id = SES.num2
1773: AND DELETED_HEADER.segment1 = SES.index_char1
1774: AND DELETED_HEADER.type_lookup_code IN (c_STANDARD,c_PLANNED,c_CONTRACT,c_BLANKET)
1775: )
1776: OR
1777: -- Check for other in-memory documents.
1778: EXISTS

Line 1821: AND SES.char2 IN (c_STANDARD,c_BLANKET)

1817: ( SES.index_char2 = 'X'
1818: OR
1819: (
1820: l_check_sourcing_flag = 'I'
1821: AND SES.char2 IN (c_STANDARD,c_BLANKET)
1822: )
1823: )
1824: ;
1825:

Line 2608: PROCEDURE validate_clm_standard_form (

2604:
2605: END mod_no_cancel_shp_complt;
2606:
2607:
2608: PROCEDURE validate_clm_standard_form (
2609:
2610: p_intf_header_id IN PO_TBL_NUMBER,
2611: p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000,
2612: p_style_id_tbl IN PO_TBL_NUMBER,

Line 2611: p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000,

2607:
2608: PROCEDURE validate_clm_standard_form (
2609:
2610: p_intf_header_id IN PO_TBL_NUMBER,
2611: p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000,
2612: p_style_id_tbl IN PO_TBL_NUMBER,
2613: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2614: x_result_type OUT NOCOPY VARCHAR2
2615: ) IS

Line 2617: d_mod CONSTANT VARCHAR2(100) := D_validate_clm_standard_form;

2613: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2614: x_result_type OUT NOCOPY VARCHAR2
2615: ) IS
2616:
2617: d_mod CONSTANT VARCHAR2(100) := D_validate_clm_standard_form;
2618: l_results_count NUMBER :=0;
2619: l_valid_standard_form VARCHAR2(1) := NULL;
2620:
2621: BEGIN

Line 2619: l_valid_standard_form VARCHAR2(1) := NULL;

2615: ) IS
2616:
2617: d_mod CONSTANT VARCHAR2(100) := D_validate_clm_standard_form;
2618: l_results_count NUMBER :=0;
2619: l_valid_standard_form VARCHAR2(1) := NULL;
2620:
2621: BEGIN
2622: -- skip the validation for non-CLM documents
2623: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN

Line 2630: PO_LOG.proc_begin(d_mod,'p_clm_standard_form_tbl',p_clm_standard_form_tbl);

2626: END IF;
2627:
2628: IF PO_LOG.d_proc THEN
2629: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
2630: PO_LOG.proc_begin(d_mod,'p_clm_standard_form_tbl',p_clm_standard_form_tbl);
2631: END IF;
2632:
2633: FOR i IN 1..p_intf_header_id.Count
2634: LOOP

Line 2635: IF p_clm_standard_form_tbl(i) IS NOT NULL

2631: END IF;
2632:
2633: FOR i IN 1..p_intf_header_id.Count
2634: LOOP
2635: IF p_clm_standard_form_tbl(i) IS NOT NULL
2636: THEN
2637: BEGIN
2638: SELECT 'Y' INTO l_valid_standard_form
2639: FROM dual

Line 2638: SELECT 'Y' INTO l_valid_standard_form

2634: LOOP
2635: IF p_clm_standard_form_tbl(i) IS NOT NULL
2636: THEN
2637: BEGIN
2638: SELECT 'Y' INTO l_valid_standard_form
2639: FROM dual
2640: WHERE p_clm_standard_form_tbl(i) IN ( SELECT DISTINCT standard_form
2641: FROM PO_PRINT_FORM_FORMATS
2642: WHERE style_id = p_style_id_tbl(i)

Line 2640: WHERE p_clm_standard_form_tbl(i) IN ( SELECT DISTINCT standard_form

2636: THEN
2637: BEGIN
2638: SELECT 'Y' INTO l_valid_standard_form
2639: FROM dual
2640: WHERE p_clm_standard_form_tbl(i) IN ( SELECT DISTINCT standard_form
2641: FROM PO_PRINT_FORM_FORMATS
2642: WHERE style_id = p_style_id_tbl(i)
2643: AND document_type = Decode (PO_PDOI_PARAMS.g_request.document_type,
2644: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,'PO_AWARD_STD_FORM')

Line 2644: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,'PO_AWARD_STD_FORM')

2640: WHERE p_clm_standard_form_tbl(i) IN ( SELECT DISTINCT standard_form
2641: FROM PO_PRINT_FORM_FORMATS
2642: WHERE style_id = p_style_id_tbl(i)
2643: AND document_type = Decode (PO_PDOI_PARAMS.g_request.document_type,
2644: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,'PO_AWARD_STD_FORM')
2645: AND inactive_date IS NULL
2646: );
2647: EXCEPTION
2648: WHEN No_Data_Found THEN

Line 2652: , p_column_name => c_CLM_STANDARD_FORM

2648: WHEN No_Data_Found THEN
2649: x_results.add_result(
2650: p_entity_type => c_entity_type_HEADER
2651: , p_entity_id => p_intf_header_id(i)
2652: , p_column_name => c_CLM_STANDARD_FORM
2653: , p_message_name => PO_MESSAGE_S.PO_PRINT_FORM_FORMAT_INVALID
2654: );
2655: l_results_count := l_results_count + 1;
2656: END;

Line 2675: END validate_clm_standard_form;

2671: PO_LOG.exc(d_mod,0,NULL);
2672: END IF;
2673: RAISE;
2674:
2675: END validate_clm_standard_form;
2676:
2677:
2678: PROCEDURE validate_clm_document_format(
2679: p_intf_header_id IN PO_TBL_NUMBER,

Line 2680: p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000,

2676:
2677:
2678: PROCEDURE validate_clm_document_format(
2679: p_intf_header_id IN PO_TBL_NUMBER,
2680: p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000,
2681: p_clm_document_format_tbl IN PO_TBL_VARCHAR2000,
2682: p_style_id_tbl IN PO_TBL_NUMBER,
2683: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2684: x_result_type OUT NOCOPY VARCHAR2

Line 2699: PO_LOG.proc_begin(d_mod,'p_clm_standard_form_tbl',p_clm_standard_form_tbl);

2695: END IF;
2696:
2697: IF PO_LOG.d_proc THEN
2698: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
2699: PO_LOG.proc_begin(d_mod,'p_clm_standard_form_tbl',p_clm_standard_form_tbl);
2700: END IF;
2701:
2702: FOR i IN 1..p_intf_header_id.Count
2703: LOOP

Line 2722: AND standard_form = p_clm_standard_form_tbl(i)

2718: FROM dual
2719: WHERE p_clm_document_format_tbl(i) IN ( SELECT document_format
2720: FROM PO_PRINT_FORM_FORMATS
2721: WHERE style_id = p_style_id_tbl(i)
2722: AND standard_form = p_clm_standard_form_tbl(i)
2723: AND document_type = Decode (PO_PDOI_PARAMS.g_request.document_type,
2724: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,'PO_AWARD_STD_FORM')
2725: AND inactive_date IS NULL
2726: );

Line 2724: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,'PO_AWARD_STD_FORM')

2720: FROM PO_PRINT_FORM_FORMATS
2721: WHERE style_id = p_style_id_tbl(i)
2722: AND standard_form = p_clm_standard_form_tbl(i)
2723: AND document_type = Decode (PO_PDOI_PARAMS.g_request.document_type,
2724: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,'PO_AWARD_STD_FORM')
2725: AND inactive_date IS NULL
2726: );
2727: EXCEPTION
2728: WHEN No_Data_Found THEN

Line 2732: , p_column_name => c_CLM_STANDARD_FORM

2728: WHEN No_Data_Found THEN
2729: x_results.add_result(
2730: p_entity_type => c_entity_type_HEADER
2731: , p_entity_id => p_intf_header_id(i)
2732: , p_column_name => c_CLM_STANDARD_FORM
2733: , p_message_name => PO_MESSAGE_S.PO_PRINT_FORM_FORMAT_INVALID
2734: );
2735: l_results_count := l_results_count + 1;
2736: END;

Line 3102: IF p_type_lookup_code_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD

3098: FOR i IN 1..p_intf_header_id.Count
3099: LOOP
3100: IF p_clm_award_type_tbl(i) IS NOT NULL
3101: THEN
3102: IF p_type_lookup_code_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
3103: THEN
3104: BEGIN
3105: SELECT 'Y' INTO is_valid_awd_type
3106: FROM dual