APPS.JAI_CMN_RG_MASTER_ORG_PKG dependencies on JAI_CMN_RG_PLA_TRXS

Line 147: p_previous_serial_no IN JAI_CMN_RG_PLA_TRXS.slno%TYPE,

143:
144: PROCEDURE insert_pla_others
145: (ERRBUF OUT NOCOPY VARCHAR2,
146: RETCODE OUT NOCOPY VARCHAR2,
147: p_previous_serial_no IN JAI_CMN_RG_PLA_TRXS.slno%TYPE,
148: p_tax_type IN JAI_CMN_RG_OTHERS.tax_type%TYPE,
149: p_register_id IN JAI_CMN_RG_PLA_TRXS.register_id%TYPE)
150: AS
151:

Line 149: p_register_id IN JAI_CMN_RG_PLA_TRXS.register_id%TYPE)

145: (ERRBUF OUT NOCOPY VARCHAR2,
146: RETCODE OUT NOCOPY VARCHAR2,
147: p_previous_serial_no IN JAI_CMN_RG_PLA_TRXS.slno%TYPE,
148: p_tax_type IN JAI_CMN_RG_OTHERS.tax_type%TYPE,
149: p_register_id IN JAI_CMN_RG_PLA_TRXS.register_id%TYPE)
150: AS
151:
152: Cursor rg_others_cur( p_register_id IN Number, p_tax_type JAI_CMN_RG_OTHERS.tax_type%TYPE ) IS
153: Select * from JAI_CMN_RG_OTHERS

Line 905: From JAI_CMN_RG_PLA_TRXS a

901: v_ec_code Varchar2(50);
902:
903: Cursor pla_cur(p_register_id IN Number) IS
904: Select *
905: From JAI_CMN_RG_PLA_TRXS a
906: Where a.register_id = p_register_id;
907: pla_rec pla_cur%ROWTYPE;
908:
909: Cursor pla_register_id_cur(p_ec_code IN Varchar2) IS

Line 911: From JAI_CMN_RG_PLA_TRXS a, JAI_CMN_INVENTORY_ORGS b

907: pla_rec pla_cur%ROWTYPE;
908:
909: Cursor pla_register_id_cur(p_ec_code IN Varchar2) IS
910: Select register_id
911: From JAI_CMN_RG_PLA_TRXS a, JAI_CMN_INVENTORY_ORGS b
912: Where ( a.posted_flag IS NULL OR a.posted_flag = 'N' ) --rchandan for bug#4428980
913: And ( a.master_flag IS NULL OR a.master_flag = 'N' ) --rchandan for bug#4428980
914: And a.organization_id = b.organization_id
915: And a.location_id = b.location_id

Line 924: From JAI_CMN_RG_PLA_TRXS

920:
921: Cursor serial_no_cur(p_organization_id IN Number, p_location_id IN Number,
922: p_fin_year IN Number /*, p_register_type Char */ ) IS
923: Select nvl(MAX(slno),0) , nvl(MAX(slno),0) + 1
924: From JAI_CMN_RG_PLA_TRXS
925: Where organization_id = p_organization_id
926: And location_id = nvl(p_location_id,0)
927: And fin_year = p_fin_year ;
928: -- And register_type = p_register_type

Line 936: From JAI_CMN_RG_PLA_TRXS

932:
933: Cursor opening_balance_cur(p_previous_serial_no IN NUMBER, p_organization_id IN Number, p_location_id IN Number,
934: p_fin_year IN Number /*, p_register_type Char*/ ) IS
935: Select nvl(opening_balance,0), nvl(closing_balance,0)
936: From JAI_CMN_RG_PLA_TRXS
937: Where slno = p_previous_serial_no
938: And organization_id = p_organization_id
939: And location_id = nvl(p_location_id,0)
940: -- And register_type = p_register_type

Line 953: FROM JAI_CMN_RG_PLA_TRXS

949: and FIN_ACTIVE_FLAG='Y';
950:
951: Cursor c_final_balance_pla(p_organization_id IN NUMBER,p_location_id IN NUMBER,p_fin_year IN NUMBER) IS
952: SELECT NVL(CLOSING_BALANCE,0)
953: FROM JAI_CMN_RG_PLA_TRXS
954: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
955: AND LOCATION_ID = P_LOCATION_ID
956: AND FIN_YEAR = P_FIN_YEAR
957: AND SLNO IN

Line 958: (SELECT NVL(MAX(SLNO),0) FROM JAI_CMN_RG_PLA_TRXS

954: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
955: AND LOCATION_ID = P_LOCATION_ID
956: AND FIN_YEAR = P_FIN_YEAR
957: AND SLNO IN
958: (SELECT NVL(MAX(SLNO),0) FROM JAI_CMN_RG_PLA_TRXS
959: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
960: AND LOCATION_ID = P_LOCATION_ID
961: AND FIN_YEAR = P_FIN_YEAR
962: );

Line 1073: INSERT INTO JAI_CMN_RG_PLA_TRXS (register_id,

1069: if v_debug_flag = 'Y' THEN
1070: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_opening_balance is ' || v_opening_balance);
1071: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_closing_balance is ' || v_closing_balance);
1072: end if;
1073: INSERT INTO JAI_CMN_RG_PLA_TRXS (register_id,
1074: fin_year,
1075: slno,
1076: tr6_challan_no,
1077: tr6_challan_date,

Line 1156: UPDATE JAI_CMN_RG_PLA_TRXS

1152: pla_rec.last_update_login,
1153: pla_rec.other_tax_credit,
1154: pla_rec.other_tax_debit);
1155:
1156: UPDATE JAI_CMN_RG_PLA_TRXS
1157: SET posted_flag = 'Y',
1158: master_flag = 'N'
1159: WHERE register_id = pla_rec.register_id;
1160: