DBA Data[Home] [Help]

APPS.GMF_LOTCOSTADJUSTMENT_PUB dependencies on FND_USER

Line 50: , x_user_id OUT NOCOPY fnd_user.user_id%TYPE

46: (
47: p_header_Rec IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type
48: , p_dtl_Tbl IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type
49: , p_operation IN VARCHAR2
50: , x_user_id OUT NOCOPY fnd_user.user_id%TYPE
51: , x_return_status OUT NOCOPY VARCHAR2
52: );
53:
54: --Global Variables

Line 139: l_user_id fnd_user.user_id%TYPE ;

135: l_api_version CONSTANT NUMBER := 2.0;
136: l_header_exists BOOLEAN;
137: l_detail_exists BOOLEAN;
138: user_cnt NUMBER;
139: l_user_id fnd_user.user_id%TYPE ;
140: l_return_status VARCHAR2(11) ;
141: BEGIN
142: -- Standard Start of API savepoint
143: SAVEPOINT Create_LotCost_Adjustment_PUB ;

Line 357: l_user_id fnd_user.user_id%TYPE ;

353: l_api_version CONSTANT NUMBER := 2.0;
354: l_header_exists BOOLEAN;
355: l_detail_exists BOOLEAN;
356: user_cnt NUMBER;
357: l_user_id fnd_user.user_id%TYPE ;
358: l_return_status VARCHAR2(11) ;
359: BEGIN
360: -- Standard Start of API savepoint
361: SAVEPOINT Update_LotCost_Adjustment_PUB ;

Line 575: l_user_id fnd_user.user_id%TYPE ;

571: l_api_version CONSTANT NUMBER := 2.0;
572: l_header_exists BOOLEAN;
573: l_detail_exists BOOLEAN;
574: user_cnt NUMBER;
575: l_user_id fnd_user.user_id%TYPE ;
576: l_return_status VARCHAR2(2) ;
577: BEGIN
578: -- Standard Start of API savepoint
579: SAVEPOINT Delete_LotCost_Adjustment_PUB ;

Line 791: l_user_id fnd_user.user_id%TYPE ;

787: l_api_version CONSTANT NUMBER := 2.0;
788: l_header_exists BOOLEAN;
789: l_detail_exists BOOLEAN;
790: user_cnt NUMBER;
791: l_user_id fnd_user.user_id%TYPE ;
792: l_return_status VARCHAR2(2) ;
793: BEGIN
794: -- Standard Start of API savepoint
795: SAVEPOINT Get_LotCost_Adjustment_PUB ;

Line 935: --| x_user_id OUT fnd_user.user_id%TYPE |

931: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type |
932: --| p_dtl_tbl IN |
933: --| GMF_LotCostAdjustment_PUB.Lc_Adjustment_dtls_tbl_Type |
934: --| p_operation IN VARCHAR2 |
935: --| x_user_id OUT fnd_user.user_id%TYPE |
936: --| x_return_status OUT VARCHAR2 |
937: --| |
938: --| HISTORY |
939: --| 22-MAR-2004 Anand Thiyagarajan - Created |

Line 954: , x_user_id OUT NOCOPY fnd_user.user_id%TYPE

950: (
951: p_header_Rec IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type
952: , p_dtl_Tbl IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_adjustment_dtls_Tbl_Type
953: , p_operation IN VARCHAR2
954: , x_user_id OUT NOCOPY fnd_user.user_id%TYPE
955: , x_return_status OUT NOCOPY VARCHAR2
956: )
957: IS
958: l_adjustment_date GMF_LOT_COST_ADJUSTMENTS.adjustment_date%TYPE;