APPS.PO_PDOI_MAINPROC_PVT dependencies on PO_PDOI_ATTR_PROCESS_PVT

Line 2487: PO_PDOI_ATTR_PROCESS_PVT.add_default_attrs;

2483:
2484: d_position := 30;
2485:
2486: -- add default attr_values and attr_values_tlp if not provided
2487: PO_PDOI_ATTR_PROCESS_PVT.add_default_attrs;
2488:
2489: d_position := 40;
2490:
2491: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_ATTR_PROCESS);

Line 2563: PO_PDOI_ATTR_PROCESS_PVT.open_attr_values

2559: PO_LOG.proc_begin(d_module);
2560: END IF;
2561:
2562: -- open cursor for query to retrieve attr value records
2563: PO_PDOI_ATTR_PROCESS_PVT.open_attr_values
2564: (
2565: p_max_intf_attr_values_id => l_max_intf_attr_values_id,
2566: x_attr_values_csr => l_attr_values_csr
2567: );

Line 2575: PO_PDOI_ATTR_PROCESS_PVT.fetch_attr_values

2571: -- fetch records from attr values interface table and process the records
2572: LOOP
2573: BEGIN
2574: -- fetch one batch of records from query result
2575: PO_PDOI_ATTR_PROCESS_PVT.fetch_attr_values
2576: (
2577: x_attr_values_csr => l_attr_values_csr,
2578: x_attr_values => l_attr_values
2579: );

Line 2619: PO_PDOI_ATTR_PROCESS_PVT.check_attr_actions

2615: EXIT;
2616: END IF;
2617:
2618: -- determine the action for each attr value record
2619: PO_PDOI_ATTR_PROCESS_PVT.check_attr_actions
2620: (
2621: x_processing_row_tbl => l_processing_row_tbl,
2622: x_attr_values => l_attr_values,
2623: x_merge_row_tbl => l_merge_row_tbl,

Line 2678: PO_PDOI_ATTR_PROCESS_PVT.open_attr_values

2674: PO_PDOI_UTL.commit_work;
2675:
2676: IF (l_attr_values_csr%ISOPEN) THEN
2677: CLOSE l_attr_values_csr;
2678: PO_PDOI_ATTR_PROCESS_PVT.open_attr_values
2679: (
2680: p_max_intf_attr_values_id => l_max_intf_attr_values_id,
2681: x_attr_values_csr => l_attr_values_csr
2682: );

Line 2760: PO_PDOI_ATTR_PROCESS_PVT.open_attr_values_tlp

2756: PO_LOG.proc_begin(d_module);
2757: END IF;
2758:
2759: -- open cursor for query to retrieve attr value records
2760: PO_PDOI_ATTR_PROCESS_PVT.open_attr_values_tlp
2761: (
2762: p_max_intf_attr_values_tlp_id => l_max_intf_attr_values_tlp_id,
2763: x_attr_values_tlp_csr => l_attr_values_tlp_csr
2764: );

Line 2772: PO_PDOI_ATTR_PROCESS_PVT.fetch_attr_values_tlp

2768: -- fetch records from attr values tlp interface table and process the records
2769: LOOP
2770: BEGIN
2771: -- fetch one batch of records from query result
2772: PO_PDOI_ATTR_PROCESS_PVT.fetch_attr_values_tlp
2773: (
2774: x_attr_values_tlp_csr => l_attr_values_tlp_csr,
2775: x_attr_values_tlp => l_attr_values_tlp
2776: );

Line 2816: PO_PDOI_ATTR_PROCESS_PVT.check_attr_tlp_actions

2812: EXIT;
2813: END IF;
2814:
2815: -- determine the action for each attr value tlp record
2816: PO_PDOI_ATTR_PROCESS_PVT.check_attr_tlp_actions
2817: (
2818: x_processing_row_tbl => l_processing_row_tbl,
2819: x_attr_values_tlp => l_attr_values_tlp,
2820: x_merge_row_tbl => l_merge_row_tbl,

Line 2876: PO_PDOI_ATTR_PROCESS_PVT.open_attr_values_tlp

2872: PO_PDOI_UTL.commit_work;
2873:
2874: IF (l_attr_values_tlp_csr%ISOPEN) THEN
2875: CLOSE l_attr_values_tlp_csr;
2876: PO_PDOI_ATTR_PROCESS_PVT.open_attr_values_tlp
2877: (
2878: p_max_intf_attr_values_tlp_id => l_max_intf_attr_values_tlp_id,
2879: x_attr_values_tlp_csr => l_attr_values_tlp_csr
2880: );