DBA Data[Home] [Help]

APPS.OZF_SUPP_TRADE_PROFILE_PUB dependencies on OZF_CODE_CONVERSION_PVT

Line 627: p_code_conv_rec IN OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_rec_type,

623: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
624: x_return_status OUT NOCOPY VARCHAR2,
625: x_msg_count OUT NOCOPY NUMBER,
626: x_msg_data OUT NOCOPY VARCHAR2,
627: p_code_conv_rec IN OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_rec_type,
628: p_mode IN VARCHAR2
629: )
630:
631: IS

Line 823: p_code_con_rec IN OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_rec_type)

819: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
820: x_return_status OUT NOCOPY VARCHAR2,
821: x_msg_count OUT NOCOPY NUMBER,
822: x_msg_data OUT NOCOPY VARCHAR2,
823: p_code_con_rec IN OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_rec_type)
824:
825: IS
826: L_API_NAME CONSTANT VARCHAR2(30) := 'Populate_code_conv_rec';
827:

Line 1770: X_created_codes_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type

1766: p_code_conversion_rec_tbl IN code_conversion_tbl_type,
1767: p_price_protection_set_tbl IN process_setup_tbl_type,
1768: x_supp_trade_profile_id OUT NOCOPY NUMBER,
1769: X_created_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type,
1770: X_created_codes_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type
1771: )
1772: IS
1773:
1774: --Code modified for bug10634985

Line 1833: l_upd_code_con_tbl OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ;

1829:
1830: l_code_conversion_rec supp_code_conversion_rec_type ;
1831: l_code_conversion_rec_tbl code_conversion_tbl_type := code_conversion_tbl_type() ;
1832:
1833: l_upd_code_con_tbl OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ;
1834: l_del_code_con_tbl OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ;
1835:
1836: l_exec_error VARCHAR2(1) := 'N' ;
1837:

Line 1834: l_del_code_con_tbl OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ;

1830: l_code_conversion_rec supp_code_conversion_rec_type ;
1831: l_code_conversion_rec_tbl code_conversion_tbl_type := code_conversion_tbl_type() ;
1832:
1833: l_upd_code_con_tbl OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ;
1834: l_del_code_con_tbl OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ;
1835:
1836: l_exec_error VARCHAR2(1) := 'N' ;
1837:
1838:

Line 2317: X_created_codes_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type,

2313: p_code_conversion_rec_tbl IN code_conversion_tbl_type,
2314: p_price_protection_set_tbl IN process_setup_tbl_type,
2315: X_created_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type,
2316: X_updated_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type,
2317: X_created_codes_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type,
2318: X_updated_codes_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type,
2319: X_deleted_codes_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type
2320: )
2321:

Line 2318: X_updated_codes_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type,

2314: p_price_protection_set_tbl IN process_setup_tbl_type,
2315: X_created_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type,
2316: X_updated_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type,
2317: X_created_codes_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type,
2318: X_updated_codes_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type,
2319: X_deleted_codes_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type
2320: )
2321:
2322: IS

Line 2319: X_deleted_codes_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type

2315: X_created_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type,
2316: X_updated_process_tbl OUT NOCOPY OZF_PROCESS_SETUP_PVT.process_setup_tbl_type,
2317: X_created_codes_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type,
2318: X_updated_codes_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type,
2319: X_deleted_codes_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type
2320: )
2321:
2322: IS
2323: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Supp_Trade_Profile_all';

Line 2327: l_crt_code_con_tbl OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ;

2323: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Supp_Trade_Profile_all';
2324:
2325: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
2326:
2327: l_crt_code_con_tbl OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ;
2328: l_upd_code_con_tbl OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ;
2329: l_del_code_con_tbl OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ;
2330: l_exec_error VARCHAR2(1) := 'N' ;
2331:

Line 2328: l_upd_code_con_tbl OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ;

2324:
2325: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
2326:
2327: l_crt_code_con_tbl OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ;
2328: l_upd_code_con_tbl OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ;
2329: l_del_code_con_tbl OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ;
2330: l_exec_error VARCHAR2(1) := 'N' ;
2331:
2332:

Line 2329: l_del_code_con_tbl OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ;

2325: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
2326:
2327: l_crt_code_con_tbl OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ;
2328: l_upd_code_con_tbl OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ;
2329: l_del_code_con_tbl OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ;
2330: l_exec_error VARCHAR2(1) := 'N' ;
2331:
2332:
2333: BEGIN

Line 2666: X_created_code_con_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ,

2662: x_return_status OUT NOCOPY VARCHAR2,
2663: x_msg_count OUT NOCOPY NUMBER,
2664: x_msg_data OUT NOCOPY VARCHAR2,
2665: p_code_conversion_tbl IN code_conversion_tbl_type ,
2666: X_created_code_con_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ,
2667: X_updated_code_con_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ,
2668: X_deleted_code_con_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type)
2669:
2670:

Line 2667: X_updated_code_con_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ,

2663: x_msg_count OUT NOCOPY NUMBER,
2664: x_msg_data OUT NOCOPY VARCHAR2,
2665: p_code_conversion_tbl IN code_conversion_tbl_type ,
2666: X_created_code_con_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ,
2667: X_updated_code_con_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ,
2668: X_deleted_code_con_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type)
2669:
2670:
2671: IS

Line 2668: X_deleted_code_con_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type)

2664: x_msg_data OUT NOCOPY VARCHAR2,
2665: p_code_conversion_tbl IN code_conversion_tbl_type ,
2666: X_created_code_con_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ,
2667: X_updated_code_con_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type ,
2668: X_deleted_code_con_tbl OUT NOCOPY OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type)
2669:
2670:
2671: IS
2672: L_API_NAME CONSTANT VARCHAR2(30) := 'Process_code_conversion';

Line 2678: l_pvt_code_con_rec OZF_CODE_CONVERSION_PVT.supp_code_conversion_rec_type ;

2674: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
2675:
2676: l_code_conversion_rec supp_code_conversion_rec_type ;
2677:
2678: l_pvt_code_con_rec OZF_CODE_CONVERSION_PVT.supp_code_conversion_rec_type ;
2679:
2680: l_crt_code_conv OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type := OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type() ;
2681: l_crt_count NUMBER := 0 ;
2682:

Line 2680: l_crt_code_conv OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type := OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type() ;

2676: l_code_conversion_rec supp_code_conversion_rec_type ;
2677:
2678: l_pvt_code_con_rec OZF_CODE_CONVERSION_PVT.supp_code_conversion_rec_type ;
2679:
2680: l_crt_code_conv OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type := OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type() ;
2681: l_crt_count NUMBER := 0 ;
2682:
2683: l_upd_code_conv OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type := OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type() ;
2684: l_upd_count NUMBER := 0 ;

Line 2683: l_upd_code_conv OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type := OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type() ;

2679:
2680: l_crt_code_conv OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type := OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type() ;
2681: l_crt_count NUMBER := 0 ;
2682:
2683: l_upd_code_conv OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type := OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type() ;
2684: l_upd_count NUMBER := 0 ;
2685:
2686: l_del_code_conv OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type := OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type() ;
2687: l_del_count NUMBER := 0 ;

Line 2686: l_del_code_conv OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type := OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type() ;

2682:
2683: l_upd_code_conv OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type := OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type() ;
2684: l_upd_count NUMBER := 0 ;
2685:
2686: l_del_code_conv OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type := OZF_CODE_CONVERSION_PVT.supp_code_conversion_tbl_type() ;
2687: l_del_count NUMBER := 0 ;
2688:
2689: l_code_conversion_id_tbl JTF_NUMBER_TABLE ;
2690: